INNER JOIN help

[Robert Mann]

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;

the above works for 2 tables looking for help as to how I would add the
other 8 tables to the sql statement?

 

Thanks

Rob