Re: select.. where like query with 'subquery'?
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 07 Jun 2008 11:47:54 GMT
Message-ID: <484a756a$0$30635$834e42db@reader.greatnowhere.com>
> from table1, table2
> where table1.id=table2.id
> and table2.name like %table1.name%
Date: 07 Jun 2008 11:47:54 GMT
Message-ID: <484a756a$0$30635$834e42db@reader.greatnowhere.com>
On Fri, 06 Jun 2008 23:33:33 +0200, buu wrote:
> select table1.*, table2.*
> from table1, table2
> where table1.id=table2.id
> and table2.name like %table1.name%
select table1.*, table2.*
from table1, table2
where table1.id=table2.id
and table2.name like '%'||table1.name||'%'
-- http://mgogala.freehostia.comrom table1, table2Received on Sat Jun 07 2008 - 06:47:54 CDT