Table Join - One to Many Relationship
Table Join - One to Many Relationship
(OP)
I am trying to join two tables that have a 1 to many relationship. Is this an outer join? I am getting duplicate records.
ie
where a.TableOne = b.TableMany (+)
ie
where a.TableOne = b.TableMany (+)
RE: Table Join - One to Many Relationship
also, whether you want an inner join or an outer join is dictated by which rows you want returned (matched and/or unmatched), not by the tables themselves
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon