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.
