outer join

Giganews Newsgroups
Subject: outer join
Posted by:  iccsi (inun…@gmail.com)
Date: Mon, 3 Oct 2011

I have following 2 tables

table A

MyID, MyData
  1        Data1
  2      Data2

table B

  MyID MyData
    2      Data3
    3      Data4

Any outer join I can get result set for all 4 records?
if not, is it the only solution is UNION.

Thanks in advance for your information,

iccsi

Replies