Thread: SQL query

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    4
    Rep Power
    0

    SQL query


    hello there.

    can someone please help im stuck!!

    i have 2 lists of numbers which have exactly the same numbers in them apart from a few. i need a query to find them few and wondered if anyone could help!

    i suppose it would be the opposite of finding duplicates!!!

    thanks for your help in advance!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,377
    Rep Power
    391
    Code:
    select * from list1 
    where numericValue not in (
    select numericValue from list2)

IMN logo majestic logo threadwatch logo seochat tools logo