Topic: 请问在SQL SERVER中如何实现一表和多表左联

  Print this page
1.请问在SQL SERVER中如何实现一表和多表左联 Copy to clipboard
Posted by: fhoibos
Posted on: 2006-02-28 17:05

ORACLE中是这样
SELECT
A.ID,
B.NAME,
C.NAME,
D.NAME
FROM
USER A,
MASTER1 B,
MASTER2 C,
MASTER3 D
WHERE
A.ID = B.ID(+)
AND A.ID = C.ID(+)
AND A.ID = D.ID(+)

请问在SQL SERVER中怎么实现
2.Re:请问在SQL SERVER中如何实现一表和多表左联 [Re: fhoibos] Copy to clipboard
Posted by: why
Posted on: 2006-02-28 19:16

use LEFT OUTER JOIN

SELECT
A.ID,
B.NAME,
C.NAME,
D.NAME
FROM
USER A
left outer join MASTER1 B on A.ID = B.ID
left outer join MASTER2 C on A.ID = C.ID
left outer join MASTER3 D on A.ID = D.ID

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923