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