I have two tables, shown below, with the following columns:
[table #Completed] Client_ID, ClientName, FirstDeliveryStatus, FirstDeliveryDate
[table #Planned] Client_ID, ClientName, NextDeliveryStatus, NextDeliveryDate
As you can see clients have some completed & planned deliveries. I'm trying to merge both tables to show for each patient :
Client_ID, ClientName, FirstDeliveryStatus, FirstDeliveryDate, NextDeliveryStatus, NextDeliveryDate
I have tried to select data from table Completed and outer/inner join table Planned but it does not realy work for me. Main issue is row 6[Ashton] who have never had any completed deliveries & once I join details about his planned delivery - i'm getting nulls on Client_ID & ClientName
I would expect to see output as per below visualization
Any help would be appreciated