|
Re: joining multiple tables [message #374647 is a reply to message #374645] |
Fri, 22 June 2001 10:23 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
Either by a simple SELECT statement or creating a
view of seven joined tables. Specify all the 7
tables in the table list after FROM with proper
aliases and specify a WHERE clause with a join
crireria on which the tables are to be joined.
SELECT columnslist FROM table1 a,table2 b,table3
c,table4 d,table5 e,table6 f,table7 g WHERE
a.columnname = b.columnname AND b.columnname =
c.columnname ...
You can give any WHERE condition based on which
the tables would be joined together.
Try it out.
|
|
|
Re: joining multiple tables [message #374648 is a reply to message #374645] |
Fri, 22 June 2001 10:26 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
Either by a simple SELECT statement or creating a
view of seven joined tables. Specify all the 7
tables in the table list after FROM with proper
aliases and specify a WHERE clause with a join
crireria on which the tables are to be joined.
SELECT columnslist FROM table1 a,table2 b,table3
c,table4 d,table5 e,table6 f,table7 g WHERE
a.columnname = b.columnname AND b.columnname =
c.columnname ...
You can give any WHERE condition based on which
the tables would be joined together.
Try it out.
|
|
|