Thank u everyone

Can you please tell me how you build these as two separate processes

and also what scripts are involved and also how do u call them

can you please give me...

Thank you

but can you tell me wat script to be used and also these tables are on different table so how do I call them ,I mean what is...

thank u very much

sorry it was late to get back with the solution

but here is it

use <database name?

go

-- The OUTER keyword following the FULL keyword is optional.

SELECT p.Name, sod.SalesOrderID

FROM Production.Product p

FULL OUTER JOIN...

thank u all

i got it solved

thank u jeff

can u provide me the script

thank u very much