Fetch the latest log for each product

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>, PHP-PGSQL <php-pgsql(at)linuxports(dot)com>
Subject: Fetch the latest log for each product
Date: 2000-08-17 16:55:35
Message-ID: 399C1907.ADE41FE7@ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
bernie.huang.vcf text/x-vcard 315 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Hoffmann 2000-08-17 17:33:03 Re: Fetch the latest log for each product
Previous Message Stephan Szabo 2000-08-17 16:15:24 Re: Continuous inserts...