3 Replies Latest reply: Apr 9, 2018 4:00 AM by Deshani Abeykoon RSS

    Show excluded values for a given date

    Deshani Abeykoon

      I have two tables.

       

      Table A has 3 fields : ID, USER_ID and DATE

      ID, USER_ID, DATE

      01, uid_001, 01-01-2016

      02, uid_002, 01-01-2016

      03, uid_001, 02-01-2016

      04, uid_003, 02-01-2016

      05. uid_004, 02-01-2016

       

      Table B has 2 fields : USER_ID and USER_NAME

      USER_ID, USER_NAME

      uid_001, user 01

      uid_002, user 02

      uid_003, user 03

      uid_004, user 04

       

      I need to display the users who are not available for a given date.

      Ex: users uid_003 and uid_004 were not available on 01-01-2016

       

      Can someone please guide me?