Compare one field to another

T

Tim Sullivan

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.
 
M

MGFoster

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
 
Top