INNER JOIN help

[Dave Cragg]

On 16 Feb 2007, at 12:04, Robert Mann wrote:

> 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

Would this do:

SELECT * from table1
	JOIN table2
	JOIN table3
	JOIN table4
	..... etc.
	USING(record_id)

Cheers
Dave