Duplicating the records while doing leftouter join

[Anonymous]

Hello ,

Below is 2 tables - 

table 1 - 

Table 2 -

Doing left outer join on  table 1 with  table 2 on file # and brining out release # from table 2. When am expanding am getting this output which is wrong-- the records are getting duplicated with release #'s with 14 records. Actual out put should be in 3rd screen shot should be 7 records the release # are duplicating . Please advice.

[Anonymous]

Hello Thankyou for your reply,  Join should be on both File # and TG/Amount then the outcome is coming as expected.

Yes if Join on only File# behaviour is right output is wrong.

[jdbuchanan71]

Why should the first line in your first table be release 273545 and not 273526?  What identifies it as belonging with 273545?  The behaviour you are seeing is exactly how a left outer join on File# only should work.