Compare one field to another

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

 

[MGFoster]

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.

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

 

[Guest]

After getting syntax correct it worked great. Thanks.