Un Matched numbers?

Results 1 to 2 of 2

Thread: Un Matched numbers?

  1. #1
    Join Date
    Dec 1969

    Default Un Matched numbers?

    How do i get the un matched numbers from my Access Tables? I have 2 tables. TableA and TableB. Have a field "IDA" in TableA and filed "IDB" in TableB. In these 2 tables most of them are same numbers but few are different and i need to display the un mathced numbers. <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Un Matched numbers?

    select tableA.*<BR>from tableA<BR> left join tableB on tableA.IDA = tableB.IDB<BR>where tableB.IDB is null

Posting Permissions

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