Home > Archive > MS SQL Server MSEQ > August 2005 > about query ..









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author about query ..
Daniel

2005-08-31, 9:28 am

Hi all,
Does anyone know what is the following query mean:
select * from abc,def from abc.xx(+) = def.xx

i have no idea about the (+) symbol..what it represent?
Thank you in advance
Best regards,
Ocurnos
Hari Prasad

2005-08-31, 8:24 pm

Hi,

Its Left outer join in Oracle. SQL Server will give you syntax error.

Thanks
Hari
SQL Server MVP

"Daniel" <Daniel@discussions.microsoft.com> wrote in message
news:8453A3AC-B95C-45B0-B117- 79EE86FCF452@microso
ft.com...
> Hi all,
> Does anyone know what is the following query mean:
> select * from abc,def from abc.xx(+) = def.xx
>
> i have no idea about the (+) symbol..what it represent?
> Thank you in advance
> Best regards,
> Ocurnos



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com