Re: Name for new function

"Dominic J. Eidson" wrote: > On Mon, 17 Jul 2000, Derick Rethans wrote: > > > how do you want to do that with: > > > > select * from table1 where t1_column1 IN (select t2_column1 from table2 where > > t2_column2 < 4); > > I don't know off the top of my head - but it ought to be possible, since > this is what the subquery PHP patch was supposed to do - at least that's > was my understanding of it. It ain't possible, really. The patch rewrites: t1_column1 IN (select t2_column1 from table2 where t2_column2 < 4); to: (t1_column = "1" or t1_column = "3") (depending upon the contents of table of course). That's no join. Derick Rethans JDI Media Solutions H.v.Tussenbroekstraat 1 6952 BL Dieren The Netherlands e-mail: d.rethans@jdimedia.nl http://www.jdimedia.nl/