Home / Questions / 198258
Accepted
Pedro Ávila
Asked: 2020-09-21 12:53:40 +0800 CST 2020-09-21 12:53:40 +0800 CST

Get information from two tables

  • 772

I work with SQL Server 2014 I have the need to obtain data from two tables for that I can do a INNER JOINdetail is that when I do this query.

sql query

I need to use EspecificacionIdto be able to do another INNER JOINin my Options table.

But the issue is that I must take the values ​​that I have EspecificacionIdin that query, it has two Specifications, the taking is dynamically, that means that I must use both in this case, but going through and taking the values ​​and then go to the Options table. How can I do it? .

My idea would be to go through the result of the returned query through a foreach or for and take the data from SpecificationId to save it in an array and with those results do INNER JOINall that in the Options table in SQL Server.

specs

Cheers!

sql

1 Answers

  1. Best Answer

    As I see it, what you need is to reach the third table [Options] by matching the first 2 tables, you can do the following:

    SELECT*
FROM EspecificacionProductos AS EP
INNER JOIN Especificaciones AS E
    ON (EP.EspecificacionId = E.EspecificacionId)
INNER JOIN Opciones AS O
    ON (EP.EspecificacionId = O.EspecificacionId)
WHERE EP.ProductId = 7

    This brings you to the extended Options table, and you might have the columns you need.

    • 3