Results 1 to 3 of 3

Thread: oracle osql question

  1. 08-25-2006, 01:30 PM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    oracle osql question

    tsql:
    select lastname
    from tablex
    where city in [ select city from tableB]


    what is the syntax for that in Oracle land?
    Reply With Quote Reply With Quote
  2. 08-25-2006, 03:38 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    That doesn't work on Oracle, works on DB2 I know.
    Reply With Quote Reply With Quote
  3. 08-28-2006, 12:25 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    This will work

    select lastname
    from tablex
    where city in (select city from tableB)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules