This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / What does this SQL statement mean?Select * from table a, table b where a.id = b.id(+);
What does this '+' stand for? Thanks
-kraft(craft);
2002-7-5
{94}
(#619929@0)
-
right out join
-lazycod(飞鹰战士);
2002-7-5
(#619943@0)
-
maybe equals to "right outer join": return all result from b, and those in a that has an equal value in b? what's your system? different DB system may have different SQL variation
-zhihaoxx(辛普);
2002-7-5
(#619945@0)
-
It's a out join used in Oracle, not in SQL Server
-ludouya(绿豆牙);
2002-7-6
(#621489@0)
-
a.id = b.id and rows from a that has no b.
-cloud2001(卷云溶月);
2002-7-5
(#620174@0)