On 16 Feb 2007, at 12:04, Robert Mann wrote:
Yes Ruslan you are correct typo on my part
select * from table1 INNER JOIN table2 where table2.record_id =
record_id;
any ides as to how I add the other 8 tables to the statement?
Table3, table4, table5, table6, table7, table8, table9, table10
All have the same PK of record_id
Would this do:
SELECT * from table1
JOIN table2
JOIN table3
JOIN table4
..... etc.
USING(record_id)
Cheers
Dave
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
