How Can I Join more than two tables in SQL

[JawedVikia80]

Hi friends This is my first post in the Forum. How Can I Join more than two tables in SQL.

[Colin Angus Mackay]

JawedVikia80 wrote: How Can I Join more than two tables in SQL. Same way as you join two tables, just keep using joins until you've joined all the tables you need. For Example:

SELECT TableA.ID as AID, TableB.ID as BID, TableC.ID as CID
FROM TableA
INNER JOIN TableB ON TableA.ID = TableB.AID
INNER JOIN TableC ON TableB.ID = TableC.BID

This example supposes there are one-to-many relationships between TableA & TableB and also between TableB & TableC. And that TableB has a foreign key to tableA called AID, and also TableC has a foreign key to TableB called BID Does this help?

---

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way! My Blog

[wgdesigner]

Dear Friend There are many types of the Joins. which type of the join u want to use?? 1-Inner join 2-Outer join 3-Self Join You have example of inner join by our one friend if u need other 2's then reply.. Raj Khatri