dakota97 Posted January 14, 2005 Posted January 14, 2005 Hi all, I need to write one SQL query to retrieve data from 3 different tables. I've 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 Quote if(computer.speed == "slow") { hamster.feed(); } if(computer.speed == "really slow") { hamster.kill(); BuyNewHamster(); }
wyrd Posted January 14, 2005 Posted January 14, 2005 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). It's 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 Quote Gamer extraordinaire. Programmer wannabe.
dakota97 Posted January 14, 2005 Author Posted January 14, 2005 Wyrd, Got it. Thanks Chris Quote if(computer.speed == "slow") { hamster.feed(); } if(computer.speed == "really slow") { hamster.kill(); BuyNewHamster(); }
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.