Re: about query ..



Hi,

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


.



Relevant Pages

  • 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)