vineetbhargav (11/24/2015)
Thanks, i tried this way only thing which is different over here is where condition i place that condition in ON instead of where and that resulted in wrong result.Will try this as well.Also is there any ways out we can break out this query into multiple queries...
Sorry i cannot provide data as the size of data is very big and i have to mask whole thing as it is senistive data.
Thanks
-Vineet
Sample data is just that, sample data. You should be able to mock a small subset of data based on but not using production data that reflects your problem domain, that includes have data that does not match between tables as well as data that does. In this case you may need about 20 rows for each to catch most of the cases you may run across in your production system.