Sorry about that...heres the code:
SELECT CH_Employee_ATT_feb.ISP_User_Last_Name,
CH_Employee_ATT_feb.ISP_User_First_Name,
CH_Employee_ATT_feb.ATT_Usage_feb.Invalid_User,
Valid_Employees.Last_Name, Valid_Employees.First_Name
FROM CH_Employee_ATT_feb, Valid_Employees
WHERE CH_Employee_ATT_feb.ISP_Employee_Badge_Number =
Valid_Employees.[Badge Number] OR (
CH_Employee_ATT_feb.ISP_User_Last_Name=Valid_Employees.Last_Name AND
CH_Employee_ATT_feb.ISP_User_First_Name=Valid_Employees.First_Name );
Thx!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
