SQL Query for Consolidation

Question

I need a little help...

I have two data tables:

Table of programmed circuits (theorical Itinerary) Table of circuits covered by the sellers (Real Itinerary) The result to be achieved:

Thanks...

Answer 1

select isnull(a.date, b.date), isnull(a.seller, b.seller), a.[theoretical itinerary], b.[real itinerary] 
from table1 a full join table2 b 
on a.date=b.date and a.seller=b.seller