Bhupesh,
I'm not entirely sure I understand your question. I think what you want is some kind of list of all the tables that have an entry for a particular employee. You could do something like this:
SELECT 'table1', <table1 primary key>, employeeID
FROM table1
where employeeID=1
UNION
SELECT 'table2', <table2 primary key>, employeeID
FROM table2
where employeeID=1
UNION
SELECT 'table3', <table3 primary key>, employeeID
FROM table3
where employeeID=1
etc.
Steve
Steve Eckhart