Get 1 Date per code in table

Hi Ahmedx ,

Thanks for the cool reply.

I tried your solution but it doesn't work. Seems to be excluding alot of data.

I basically have 2 subsets of data (2 queries which I append into 1) - See screenshot

The resulting table must have all data from Table 1 and not matching rows from the 2nd Table.

So from table 2 in this example, I want to show the rows from 1st April to 5th April.

Business   Date               Time           Code     isdefault
A                28/03/2023 0700-2100  N          FALSE
A                29/03/2023 0700-2100  N          FALSE
A                30/03/2023 0700-2100  N          FALSE
A                31/03/2023 0700-2100  N          FALSE
A                1/04/2023 0700-2100     T          TRUE
A                2/04/2023 0700-2100     T          TRUE
A                3/04/2023 0700-2100     T          TRUE
A                4/04/2023 0700-2100     T          TRUE
A                5/04/2023 0700-2100     T          TRUE

Thanks