<div>
Try:<br />
<br />
SELECT TableC.Field1, TableD.Field1<br />
FROM TableA <br />
INNER JOIN TableB ON TableA.FK1 = TableB.FK1<br />
INNER JOIN TableC ON TableB.FK2 = TableC.FK2<br />
INNER JOIN TableD on TableB.FK3 = TableD.FK3
</div>


Try:

SELECT TableC.Field1, TableD.Field1
FROM TableA
INNER JOIN TableB ON TableA.FK1 = TableB.FK1
INNER JOIN TableC ON TableB.FK2 = TableC.FK2
INNER JOIN TableD on TableB.FK3 = TableD.FK3

<div>
You can nest joins. Let's assume your other tables are TableC and TableD:<br />
<br />

<pre><code id="code-20-36507237-1">SELECT TableA.FK1, TableB.FK_C, TableB.FK_D
FROM TableA INNER JOIN TableB ON TableA.FK1 = TableB.FK1
    INNER JOIN TableC ON TableB.FK_C = TableC.FK_C
    INNER JOIN TableD ON TableB.FK_D = TableD.FK_D</code></pre>
</div>


You can nest joins. Let's assume your other tables are TableC and TableD:



SELECT TableA.FK1, TableB.FK_C, TableB.FK_D
FROM TableA INNER JOIN TableB ON TableA.FK1 = TableB.FK1
    INNER JOIN TableC ON TableB.FK_C = TableC.FK_C
    INNER JOIN TableD ON TableB.FK_D = TableD.FK_D

<div>
<div class="content wysiwyg-content">
I need some help with a query I am trying to formulate - here is the scenario - I have 2 tables Table A has a FK to Table B - I need data from Table A provided rows for that data exist in Table B so this query does the job<br />
<br />
SELECT TableA.FK1 FROM TableA INNER JOIN TableB ON TableA.FK1 = TableB.FK1<br />
<br />
Now once I have the common FK I need to pull some data from table B - TableB has FK's to 2 other tables - how do I write one query to get all the data I need i.e that from table A and table B ?<br />
<br />
Thanks
</div>
</div>


I need some help with a query I am trying to formulate - here is the scenario - I have 2 tables Table A has a FK to Table B - I need data from Table A provided rows for that data exist in Table B so this query does the job

SELECT TableA.FK1 FROM TableA INNER JOIN TableB ON TableA.FK1 = TableB.FK1

Now once I have the common FK I need to pull some data from table B - TableB has FK's to 2 other tables - how do I write one query to get all the data I need i.e that from table A and table B ?

Thanks

SQL Query Help

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.