mysql left outer join
- by tirso
hi to all
I have two tables employee and timecard, employee table has fields employee_id,firstname,middlename,lastname and timecard table has fields employee_id,time-in,time-out,tc_date_transaction. I want to select all employee records which have the same employee_id with timecard and date is equal with the current date. If there are no records equal with the current date then return also the records of employee even without time-in,timeout and tc_date_transaction.
I have query like this
SELECT *
FROM employee LEFT OUTER JOIN timecard
ON employee.employee_id = timecard.employee_id
WHERE tc_date_transaction = "17/06/2010";
result should like this:
employee_id,firstname, middlename, lastname,time-in,time-out,tc_date_transaction
1,john,t,cruz,08:00,05:00,17/06/2010
2,mary,j,von,null,null,null
any help would greatly appreciated
Thanks in advance