Simple query

Results 1 to 2 of 2

Thread: Simple query

  1. #1
    Join Date
    Dec 1969

    Default Simple query

    Hello all,<BR> this might be very easy but I am not sure how to approach. I have two tables with one field in one table as subset of a field in the other table. I would like to write the query that gives the records that are not in the secod table (subset table). If this is wrong place to post this please excuse me.<BR><BR>Bye<BR>rajesh<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Simple query

    This should do it.<BR><BR>Select * From Table1 Where TheId Not In (Select Distinct TheId From Table2)

Posting Permissions

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