Whats the error you are getting?
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
)
----- Original Message -----
From: "Conaway, Amy C" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 10:50 AM
Subject: oops!
> ..it would help if I pasted 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) ;
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Get the mailserver that powers this list at
http://www.coolfusion.com
