Re: question about subqueries

2010-07-12 Thread cricket
On Mon, Jul 12, 2010 at 6:40 PM, breakintheweb wrote: > I've been working on a subquery for several hours and can't figure it > out in cakephp. I've tried mimicking the example in the book under > complex find conditions and couldn't seem to make that work. > > Here is the query that when run manu

question about subqueries

2010-07-12 Thread breakintheweb
I've been working on a subquery for several hours and can't figure it out in cakephp. I've tried mimicking the example in the book under complex find conditions and couldn't seem to make that work. Here is the query that when run manually in mysql works. The inner query is used to take out the dup