sql - Am I doing this join right? Three way table join -

im trying join 3 tables in following format.

select *   inner join b (inner join (c on c.id=b.c_id))  on a.id=b.a_id;

ive never used lookup table perform join (in case b).

oracle throws error saying

ora-00905: missing keyword 00905. 00000 -  "missing keyword" *cause:     *action: error @ line: 6 column: 11

any insight on im going wrong appreciated . thanks!

rather try like

select * inner join b on a.id = b.a_id inner join c on c.id = b.c_id

You