SQL中的多表查询，以及JOIN的顺序重要么？

说法是，一般来说，JOIN的顺序不重要，除非你要自己定制driving table。

 

示例：

SELECT a.account_id, c.fed_id, e.fname, e.lname
    -> FROM account AS a INNER JOIN customer AS c
    -> ON a.cust_id = c.cust_id
    -> INNER JOIN employee AS e
    -> ON a.open_emp_id = e.emp_id
    -> WHERE c.cust_type_cd = 'B';