FInd a particular Record from more than 2 Tables in sql
Solution 1:
You haven't provided much info... so here's my untested guess:
SELECT name
FROM
(
SELECT * FROM Customer_table WHERE name = 'aaa';
UNION ALL
SELECT * FROM Employee_table WHERE name = 'aaa';
UNION ALL
SELECT * FROM Workers_Table WHERE name = 'aaa';
UNION ALL
) tbl
GROUP BY name
HAVING count(*) = 1