Its Left outer join in Oracle. SQL Server will give you syntax error.
Thanks
Hari
SQL Server MVP
"Daniel" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8453A3AC-B95C-45B0-B117-79EE86FCF452@xxxxxxxxxxxxxxxx > 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
Re: master db ... > In this case you can have a common database user and keep a application ... >>> It is always better to create SQL Server Logins rather than ... >>> Hari... >>> SQL Server MVP... (microsoft.public.sqlserver.clients)
Re: how to restore ... There was typo error in Jens post....Hari...SQL Server MVP... >>> May I restore them into my new sql server?... (microsoft.public.sqlserver.clients)
Re: Error 5123 Cannot Attach DB ... I will try the stopping of SQL Server and do the file move/renames after ..."Hari Prasad" wrote: ... >> I cannot copy the files as I get the same lock error.... >>> SQL Server MVP... (microsoft.public.sqlserver.connect)
Re: Current_Date function ... If you can post to where MS documents the syntax you tried, ... Tibor Karaszi, SQL Server MVP... >>> Sounds simple enough but it always returns "Syntax Error... (microsoft.public.sqlserver.tools)
Re: master db ... In this case you can have a common database user and keep a application ...Hari...SQL Server Mvp... >> SQL Server MVP... (microsoft.public.sqlserver.clients)