How to invoke a two field check in a query

  • Thread starter Thread starter Vadimbar
  • Start date Start date
V

Vadimbar

Hello,
I have a query that returns an assets previous and current room, building
location. I need to check if old building is different from new building then
if they match check if old room matches new room if they all match I don't
need to see them. I only want to see where any of these fileds differ. Any
ideas please? Greatly appreciated.
Vadimbar...
 
Try this --
SELECT [Previous_room], [Current_building], [Current_room],
[Previous_building], location
FROM YourTable
WHERE [Previous_room]<>[Current_room] And
[Current_building]<>[Previous_building];
 
Back
Top