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

Reply via email to