在甲骨文中我有:
SELECT t2.Regkood, t2.naitatel, t2.naitafaks, t3.lahtiolekuaeg, t1.*
FROM table1 t1, table2 t2, table3 t3
WHERE t1.client = t2.client AND t1.client = t3.client(+) AND t1.client = 414246
如何在 SQL Server 中获得相同的结果?
thanks
SELECT t2.Regkood,
t2.naitatel,
t2.naitafaks,
t3.lahtiolekuaeg,
t1.*
FROM table1 t1
INNER JOIN table2 t2
ON t1.client = t2.client
LEFT JOIN table3 t3
ON t1.client = t3.client
WHERE t1.client = 414246
一些了解连接的示例:
ORACLE 中的左外连接
SELECT *
FROM A, B
WHERE A.column = B.column(+)
ORACLE 中的右外连接
SELECT *
FROM A, B
WHERE A.column(+)=B.column
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)