Find method with multiple tables

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 cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.