how to check the value simaltanously from 2 table

[biswa47]

there is 2 table named table 1 and table 2 in the db where both table have a comman coloumn named employee_code. let table1 conatain emplyee_code-1,2,6,8,9 and table2 contain employye_coce-2,4,6,7,8 now i want a sql statement which will give me the out put as follows i want to check(let say employee code1) wather a particular employee_code present in table 1 and not present in table2 .if it run succesfully it should give massage emplyee code exists else doesn't exists. means if i select emp_code 1 then the message would be "emplyee code exists" i select emp_code 2 then the message would be "emplyee code doesnt exists"

[pmarfleet]

Use the EXISTS[^] operator to check for the existence of rows with a particular employee code in table 2.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush