Based on the sample data.. What is the query could i display any data exist on TableA but not exist on TableB
based on the sample data...
ON TableB.Date = TableA.Date
AND TableB.Time = TableA.Time
AND TableB.Number = TableA.Number
AND TableB.Charge = TableA.Charge
WHERE TableB.Date IS NULL
Originally Posted by bh_hensem
or any data exist on TableB but not exist on TableC.