三表连接a,b,c a和b先内连接，再和c外连接,该怎么写

Question

三表连接a,b,c a和b先内连接，再和c外连接,db2 该怎么写
select * from a inner join b
on a.id = b.id
left outer join c on b.oid = c.oid
这样写对不对？

Answer 1

select * from (select * from a inner join b on a.id=b.id) t out join c on t.id=c.id