Date field is getting repeated from one table

[MS90]

Shipment updated date is repeating from table b and causing duplicate values

Table a:

Load 

Key id,

Shipment start date ,

Shipment end date;

Table b:

Load

Key id,

Shipment updated date;

key id	shipment start date	shipment end date	shipment updated date
1	07/01/2023	07/07/2023	07/11/2023
1	07/20/2023	07/28/2023	07/13/2023
2	07/01/2023	07/01/2023	06/10/2023
2	07/04/2023	07/04/2023	06/15/2023
2	07/11/2023	07/11/2023	-
2	07/11/2023	07/13/2023	-
key id	shipment start date	shipment end date	shipment updated date
1	07/01/2023	07/07/2023	07/11/2023
1	07/01/2023	07/07/2023	07/13/2023
1	07/20/2023	07/28/2023	07/11/2023
1	07/20/2023	07/28/2023	07/13/2023
2	07/01/2023	07/01/2023	06/10/2023
2	07/01/2023	07/01/2023	06/15/2023
2	07/04/2023	07/04/2023	06/10/2023
2	07/04/2023	07/04/2023	06/15/2023
2	07/11/2023	07/11/2023	06/10/2023
2	07/11/2023	07/11/2023	06/15/2023
2	07/11/2023	07/13/2023	06/10/2023
2	07/11/2023	07/13/2023	06/15/2023

[anat · Accepted solution]

can you share Tablea and Tableb data,seems in tableb you have multiple entries for 1 keyid

[MS90]

Please find the data Tablea

key id	shipment start date	shipment end date
1	07/01/2023	07/07/2023
1	07/20/2023	07/28/2023
2	07/01/2023	07/01/2023
2	07/04/2023	07/04/2023
2	07/11/2023	07/11/2023
2	07/11/2023	07/13/2023

Tableb

shipment updated date	key id
07/11/2023	1
07/13/2023	1
06/10/2023	2
06/15/2023	2