Forum Discussion
Duplicating the records while doing leftouter join
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...
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.