Hi, I bet people have asked this question several times, but oh well, please do anwser again. Thanks. =) I have a product table and a log file. product_tb ----------- prod_id prod_name ... log_tb --------- log_id prod_id cust_id transact_date ... How do I fetch the latest log for each product according to transaction date? - Bernie
begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard