0
Hi Narasimhan,
Can you Please Post your table structure. The resultant output depends on the Table Definition and the rows it contain.
And, the DISTINCT Keyword where the other columns of a Table might have unique values.
Thanks, Shanka M
0
it is very difficult unless we have visibility to data for all the tables mentioned in the email. you can try removing the facname where condition and see if you receive the same data, or try giving an invalid value in the where condition like fa.facname = 'NAMEDOESNOTEXIST' and see what comes up.