Combine Queries with LIKE Clause

I have two queries:

select deptname from table1 (return 3 rows)

select saleman from table2 where dept_desc LIKE '%table1.deptname%' (repeat 3 times)

How to combine them together? Received on Sat Jan 18 2003 - 10:11:54 CST