syntax of outer join for sybase


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: syntax of outer join for sybase

  1. #1
    nonmin Guest

    syntax of outer join for sybase


    Hi,

    Could you tell me syntax of outer join for sybase?
    I know that for oracle, the syntax is
    A.colName = B.colName(+)

    Thanks very much.

    nonmin

  2. #2
    Craig Clearman Guest

    Re: syntax of outer join for sybase

    >Could you tell me syntax of outer join for sybase?

    Roughly like this:

    SELECT column_list
    FROM table1, table2
    WHERE table1.key_column1 *= table2.key_column1 AND
    table1.key_column2 *= table2.key_column2

    Ciao, Craig


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center