I'm stuck with a typical problem. I have a few tables, and I need to extract data from only 1 table using conditions in other 3. As usual, I'm using Semi-Join and an intersection of all the 3 conditions.
I cannot post any data because of high security issues, so please help me out.
Now, I get the semi join results from all 3 conditions and use intersection to get the common details. However, I think that the resulting table will have duplicates because only that table's attributes are used. Any idea how I can remove those???