This SQL command does not work:

SELECT "Date Opened", "ICardTellerID", "Status","Cash
Collected",
"Terminal","Employee", "Last_Name", "Drawer Number" FROM 
"Drawer
File" left outer join "Employee" on "Employee" = 
"Employee Number"
Where Status <> 0 Order By "Last_Name"

Error message:
DBISAM Engine Error # 11949 SQL error - Type mismatch between column
'Employee Number' and constant 'Employee' WHERE or JOIN clause.

This SQL does work:

SELECT "Date Opened", "ICardTellerID", "Status","Cash
Collected",
"Terminal","Employee", "Last_Name", "Drawer Number" FROM 
"Drawer
File" left outer join "Employee" on [Employee] = [Employee 
Number]
Where Status <> 0 Order By "Last_Name"