quote:

---

Originally posted by irfi

Hi everyone!
This is my first post and i would appreciate if someone could help me with the SQL Query to look for records in first table and then if not found look in second table and populate the fields on my windows form. In case records not found in both tables then i will display records not found.

"Select a.id, a.name, b.dept from emp_table1 a, dept b where a.id = b.id and a.id=" & Text1.text"

"Select a.id, a.name, b.dept from emp_table2 a, dept b where a.id = b.id and a.id=" & Text1.text"

Thanks and Cheers!
IrFi

---

"SELECT a.id, a.name, b.dept 
FROM (SELECT id, name from emp_table1 
      union 
      Select id, name from emp_table2 
     )a
dept b 
where a.id = b.id and a.id=" & Text1.text"