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