Results 1 to 3 of 3

Thread: sql statement

  1. Mar 24th, 2000, 12:44 AM #1
    Thai
    Thai is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Posts
    168
    Hello again.

    If Table1 and Table2 both have the field called NUMBER, what sql statement would I use to return all fields from Table1, where NUMBER from Table1 DOES NOT exist in NUMBER from Table2? I've been trying a few things but none work, please help if you can.

    Thai
    Reply With Quote Reply With Quote
  2. Mar 24th, 2000, 01:02 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    select * from table1 where number not in (select distinct number from table2)
    Reply With Quote Reply With Quote
  3. Mar 24th, 2000, 02:16 AM #3
    Thai
    Thai is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Posts
    168

    It worked. Thanks :)

    Thanks for the help, it works now

    Thai
    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


Click Here to Expand Forum to Full Width