Re: select.. where like query with 'subquery'?

"buu" <aha_at_a.com> wrote in news:g2cafc0k9h_at_enews5.newsguy.com:

> I would like to create a query like this:
>
> select table1.*, table2.*
> from table1, table2
> where table1.id=table2.id
> and table2.name like %table1.name%
>
>
> so, the problem is how to put the last part with LIKE clause wich
> should be from another table..
> anybody any idea?
>
>
>

You need to re-think your database model.

As is, there is no simple SQL-clause to do it. You need to use dynamic SQL to get what you want, if you can't re-structure your data. Received on Fri Jun 06 2008 - 17:12:33 CDT