Hi ganesh , may i know the difference between 'AND _sheader = 'C' ' condition used for filtering in direct select statement and Where condition after the parathesis. Thanks in advance
I showed you an option to add the condition as well in the JOIN process. But preferable is use joins only to connect tables and the conditions to be in the WHERE clause.