Fetch the latest log for each product - Mailing list pgsql-sql

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