I'm using the below query to fetch only the unique "emailid" field value but still I'm getting duplicates
SELECT Distinct Emailid , EmailName FROM _job a WHERE a.SuppressTracking=0 and a.EmailName not like '%welcome%' union select Distinct Emailid , EmailName FROM ent.[Sentio Tagging] b where b.AccountID = 6323126
Sentio Tagging table , there are no duplicate records, the duplicate records are coming from
Can anyone please assist me.