select query from different tables

riteshsingh92 · New User Joined: 10 Nov 2009 Posts: 17 Location: India

Can someone help me to write select query for different fields from more then five tables.

dick scherrer · Posted: Fri Nov 13, 2009 4:27 am

Maybe. . . .

You need to invest some more keystrokes and post what you have to work with and what you want to accomplish.

Showing a bit of sample data from the 5 tables and what you want as "output" from the query will help someone help you.

Joining 5 tables is quite similar to joining 2 - there are just more relationship considerations (that you will have to identify as we know nothing about your database).

dbzTHEdinosauer · Posted: Fri Nov 13, 2009 4:30 am

SELECT A.COL1, B.COL1,C.COL1,D.COL1,E.COL1
FROM TABLE1 A, TABLE2 B, TABLE3 C, TABLE4 D, TABLE5 E
WHERE ......