Search results

  1. M

    LEFT JOIN equals ID and between two dates

    Exactly what I was looking for. Thank you so much!
  2. M

    LEFT JOIN equals ID and between two dates

    HI there, thanks for the quick reply. Your query only returns the Johnson and Sikes records. I would like it to return ALL records from Table 1, and a Null in the Supervisor column when it can't find a match.
  3. M

    LEFT JOIN equals ID and between two dates

    Hi all, Hoping someone can help me with query I'm having trouble with. I want to do a left join and keep all records in Table 1, and matching records in Table 2 where Table 1 ID = Table 2 ID, AND Table 1 RowDate is between Table 2 StartDate and EndDate. I'm going to try to attach a sample DB...
Top Bottom