Results 1 to 2 of 2

Thread: JOIN queries

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: JOIN queries

    Hi,

    Can you give the equivalent query for the following Oracle query :

    SELECT col2, col3 FROM submission,
    lkup so
    WHERE so.txt (+) = TRIM(col2)
    AND so.pid (+) = 'SO'
    AND so.cde (+) = 'RW'

    In the above query a constant value is used in JOIN, so I am not aware of how to use the JOIN clause for the above constant value ( 'SO' , 'RW' )

    Upto my knowledge about JOIN query equivalents :

    Oracle query :-

    select *from test1 a, test2 b where a.sno(+) = b.col

    Equivalent SQL Server query :-

    select *from test1 a RIGHT JOIN test2 b on a.sno = b.col

    Hope the above is correct. Here my doubt is, if in the above query, b.col is replaced by a constant value say 'abcd' , then what will be the table name used in right of the JOIN clause. Or any other equivalent for this is available ?

    Eg :-

    Oracle query :-

    select *from test1 a, test2 b where a.sno(+) = 'abcd'


    Thanks,
    Sam

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sam,

    The(+) is an outter join right?

    How can you do an outter join to a literal?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •