Trying to write an INNER Join SQL statement for 10 tables that only returns
one record base on PK record_id

 

select * from table1 INNER JOIN table2 where table2.record_id is record_id;

the above works for 2 tables looking for help as to how I would add the
other 8 tables to the sql statement?

 

Thanks

Rob

_______________________________________________
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

Reply via email to