select.. where like query with 'subquery'?

From: buu <aha_at_a.com>
Date: Fri, 6 Jun 2008 23:33:33 +0200
Message-ID: <g2cafc0k9h@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? Received on Fri Jun 06 2008 - 16:33:33 CDT

Original text of this message