INNER JOIN help

[Robert Mann]

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

Or is there a better why to combine info from 10 tables into one using SQL?

Thanks
Rob

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of Ruslan
Zasukhin
Sent: Friday, February 16, 2007 2:43 AM
To: use-revolution
Subject: Re: INNER JOIN help

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]


_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution