我必须显示不在“timecard”表中的记录-

tcID Primary int(11)                    
RequestID int(11)           
StaffID int(11)             
ShiftStartDate date             
ShiftEndDate date               
JobStartTime time           
JobEndTime time         
lunchTaken time         
ApprovalCode varchar(45)

查询：

SELECT *
FROM acceptedrequest ar
LEFT JOIN staff s ON s.StaffID = ar.StaffID
LEFT JOIN staffposition sp ON sp.PositionCode = s.PositionCode
WHERE
  ar.AgencyID = 0
  AND ar.RequestID = 2364
  and RepalceStatus = 0
  and ar.CancelStatus = 0
  and ar.BroadcastStatus = 0