INNER JOIN help

[Ruslan Zasukhin]

On 16/2/07 1:32 AM, "Robert Mann" <robmann at gp-racing.com> 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]