Left table has cost data along with product, account hierarchy details
Right table is considered as exclusion , has list of product hierarchy details .Also included and marked extra flag to indicate it's from right table
Resultant table using Left outer needs to have no matching records from right one.
But it gives out all entries in left table but doesn't exclude data from right table
These product and account hierarchy has numeric and character type column values
Can you help point what can be the issue with approach
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.