Dear All, Now I can solve it by using query function instead of find and use my sql query language instead of cakephp language syntax.
However, I will post my code later because I still want to find out to use cakephp syntax with complex find condition. Thanks a lot for your taking time to help. I think that it's more easy to contact me on skype my email is [email protected] or lydara9. Sincerely Yours, Dara, On Sun, Sep 16, 2012 at 1:04 PM, Mike Griffin <[email protected]> wrote: > Code, code, code, code, code. Show what you have tried. > > And saying something is urgent (has everything you posted been urgent?) > won't help in most cases. > > -- > Mike Griffin > Sent with Sparrow <http://www.sparrowmailapp.com/?sig> > > On Sunday 16 September 2012 at 05:09, Mr. Manager wrote: > > Dear All, > > I have problem with using find method to retrieve field from many table. > > I have table as the following: > > items(id, no, name, price, discount, sample, outside) > invoices(id, no, name, patient_id, doctor_id, source_id, discount, > paying_date, request_date, exchange_rate, bad) > invoice_details(id, invoice_id, item_id, price) > sources(id, no, name, phone, address) > > The condition of find is about the date with $start_date, $end_date that > should be filter in table invoices and source_id. > > The preferable result > No Item Name Number_of_Item > Price Total_Price > > > This is urgent and I hope that anyone can help me find the solution. > > Thanks a lot in advance. > Dara, > > -- > 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-US. > > > > > -- > Like Us on FacekBook 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. > > > -- Like Us on FacekBook 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.
