Re: Find method with multiple tables

2012-09-16 Thread Mike Griffin
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

Re: Find method with multiple tables

2012-09-16 Thread Ly Dara
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

Find method with multiple tables

2012-09-15 Thread Mr. Manager
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)