Compare one field to another

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

Guest

I have a table that has 5 fields with 5000+ records.
Fields are:
Employee Name
Employee Budget code
Store budget code
Store Type
Hours worked.

What I want is a query that will show me the records where the Employee
budget code does not match the Store budget code.
 
Tim said:
I have a table that has 5 fields with 5000+ records.
Fields are:
Employee Name
Employee Budget code
Store budget code
Store Type
Hours worked.

What I want is a query that will show me the records where the Employee
budget code does not match the Store budget code.
Click to expand...

SELECT EmployeeName, EmployeeBudgetCode, StoreBudgetCode, StoreType,
HoursWorked
FROM table_name
WHERE EmployeeBudgetCode <> StoreBudgetCode
 
Back
Top