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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[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 _______________________________________________ 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
