Thursday, May 30, 2013

Joing two databases and then Outer Joining

Hi ,


I;m fairly new at SQL 2012 so hopefully someone can help me.


I've been asked to do the following on some tables and could use some input.


I want join fron database A table1 and table2.


I would assume that I need to look at these table and determine what is the common primary key.


Then after joining these tables I need to "outer join" Table 1 and 2 to database B table 3


I thought to use Management studio. would this be the correct join cpmmand?


select table1, table2


From Database A


Where primary key = primary key


I don't know how to write the outer join statement from here. Any suggestions?


thanks


Steve




Steve


No comments:

Post a Comment