Display Missing Rows from Tables of MSSQL
i have two data table one is :
"cards" Table which Contains :
id Department 0000022288 COR 0000043880 NA
0000031643 NA
0000013870 TRAN 0000053900 COR 0000055452 IOR 0000010957 IOR 0000025746
BILL 0000061783 BILL 0000000773 NA
I have another table (valid_entry):
date emp_id emp_time 20130101 0000002001 101825
20130102 0000002001 085024
20130103 0000002001 085657
20130106 0000002001 095145
20130107 0000002001 090724
20130108 0000002001 091244
i want to display those id which are not in valid table.
my query: SELECT
emp_valid_date,emp_valid_name,emp_valid_time,emp_valid_dept,Name FROM
valid_entry INNER JOIN Cards ON emp_valid_dept = Depart_Code WHERE
emp_valid_date = '$date' AND emp_valid_time >= 060000 AND emp_valid_time
<= 230000 AND emp_valid_dept != 'DRI' or emp_valid_time = ''
No comments:
Post a Comment