From: Adaś <adamn@qwe.pl>
To: pgsql-sql@postgresql.org
Subject: problem with sql
Date: Sun, 19 Oct 2003 16:56:10 GMT
Message-ID: <Kmzkb.25189$bU3.325187@news.chello.at> (raw)
Hello to everyone,
In my own database, I linked customers table with orders table using
one-to-many relation. I need to check status of last order for each
customer and then set customer's status. I made a query using LAST and
GROUP BY to select last order for each customer and I wanted to use it
in UPDATE query, but it seems to be impossible. Is here anybody who
knows how to solve this problem? (I work with MS Access).
Adam
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adamn@qwe.pl
Subject: Re: problem with sql
In-Reply-To: <Kmzkb.25189$bU3.325187@news.chello.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox