out join 多表如何写？

[other1999]

out join 多表如何写？
一：from 表1 LEFT OUTER JOIN 表2，表3
二：from 表1 LEFT OUTER JOIN 表2，LEFT OUTER JOIN 表3
三：from 表1 LEFT OUTER JOIN 表2，表2 LEFT OUTER JOIN 表3

可我试了还不行！！！！！！！

[SophiaWang]

LEFT OUTER JOIN or LEFT JOIN


RIGHT OUTER JOIN or RIGHT JOIN


FULL OUTER JOIN or FULL JOIN


USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM authors a LEFT OUTER JOIN publishers p
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC


USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM authors AS a RIGHT OUTER JOIN publishers AS p
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC

USE pubs
SELECT s.stor_id, s.qty, t.title
FROM sales s RIGHT OUTER JOIN titles t
ON s.title_id = t.title_id
AND s.qty > 50
ORDER BY s.stor_id ASC

[SophiaWang]

USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM authors a FULL OUTER JOIN publishers p
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC

[CrazyFor]

from 表1 LEFT OUTER JOIN 表2 on 表1.字段=表2.字段 left join 表3 on 表2.字段=表3.字段

[pengdali]

..from 表1 LEFT JOIN 表2 on 表1.id=表2.id
LEFT JOIN 表3 on 表2.id=表3.id

[SophiaWang]

select a.*,b.id,c.name
from 表1 a left outer join 表2 b on a.id = b.id
left outer join 表3 c on a.id = c.id