Compare tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A simple one, but I'm having a total brain freeze.

I have two tables, tabtapescopy & sheet1.

Both have two fields, TapeID & RDate

I need to run a query to compare the two tables to bring up a list of tapes
which have the same Tape ID but different Return Dates.

Can anyone help..


Thanks
 
Add both tables to the grid
Join on TapeID to TapeID
Under one RDate enter not equal to the other table RDate

SELECT A.TapeID, A.RDate, B.RDate
FROM TabTapesCopy as A INNER JOIN Sheet1 as B
 
Back
Top