Hi,

i have a model which belongs to another like "model car belongs to 
rent-time".
in table for rent-time there are two timestamps (start and end).
now i want to modify every find-statement for model car and add a subquery 
like this:

select *, (select id from rent-time where start >= time() and end <= time() 
and car_id = $car_id limit 0,1) as rent-time from car

is it possible to modify original statement to add a subquery?

M.

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.


Reply via email to