lets say there are 3 tables employee,student,employer and all three has a Address column
use this query to see in which table the text is available.
SELECT a.Address as employeeAddress,
b.Address as studentaddress,
c.Address as employeraddress
FROM employee a left outer join
on a.empcode = b.stid
left outer join
on b.stid = c.EmployerCode
a.Address like '%texttobesearched%'
b.Address like '%texttobesearched%'
c.Address LIKE '%texttobesearched%'
Hope this helps!