Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: table data for IN keyword

    I want a WHERE clause to be something like:
    WHERE ID NOT IN ('v1','v2','v3',...) but I want the v1,v2,v3,... to be the result of a select from another table. Is this possible?

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: table data for IN keyword

    I want a WHERE clause to be something like:
    WHERE ID NOT IN ('v1','v2','v3',...) but I want the v1,v2,v3,... to be the result of a select from another table. Is this possible?
    Depends on your rdbms.

    With most you can do this:

    select a,b,c
    from mytable
    where id not in (select id from anothertable)

  3. #3
    Join Date
    Feb 2003
    Posts
    2

    Talking

    That worked! Thank you very much

Posting Permissions

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