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
student b
on a.empcode = b.stid
left outer join
employer c
on b.stid = c.EmployerCode
where (
a.Address like '%texttobesearched%'
OR
b.Address like '%texttobesearched%'
OR
c.Address LIKE '%texttobesearched%'
)
Hope this helps!