Join multiple tables???

[dakota97]

Hi all,

I need to write one SQL query to retrieve data from 3 different tables. Ive joined 2 tables successfully, but how do I get the third in there?


SELECT * FROM tblOrders INNER JOIN tblCustomer ON tblCustomer.AccountNum=tblOrders.AccountNum WHERE tblOrders.Voided=False;


Thanks in advance,

Chris

 

[wyrd]

Just add another INNER JOIN after your first one.

All of your syntax related questions can be answered in the MS SQL BOL (Books Online). Its a help file you can download that explains and shows examples of all of the SQL commands, plus much more. You can download it here:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

 

[dakota97]

Wyrd,

Got it. Thanks

Chris