On 16/2/07 1:32 AM, "Robert Mann" <[EMAIL PROTECTED]> wrote:
> 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;
Must be not IS but =
where table2.record_id = 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?
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
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
