相互关联的三个表的查询问题

Question

问题能不能说清楚点，
例如：a\b\c表，中的 id字段关联
select a.(字段a),b.(字段b),c.(字段c) from a,b,c where a.id=b.id and b.id=c.id

Answer 1

select a.col,b.col,c.col from a left join b on a.id=b.id left join c on b.id=c.id是这意思吗？

Answer 2

left join？
应该是内连接吧？
直接写join就可以了吧？
请指点！
                                                      别来烦我！
                                                    帅         富
                                                    吗         吗
                                                    ？         ？
                                                    丑         穷
                                                    得         得
                                                    不         没
                                                    敢         钱
                                                    出         吃
                                                    门         饭
                                                     ！         ！