Re: Combine Queries with LIKE Clause

Sam wrote:

> 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?

Likely the problem is that you have created a Cartesian join. But without seeing your SQL it is impossible to know.

Daniel Morgan Received on Sat Jan 18 2003 - 11:11:42 CST