problem with sql - Mailing list pgsql-sql

From Adaś
Subject problem with sql
Date
Msg-id Kmzkb.25189$bU3.325187@news.chello.at
Whole thread Raw
Responses Re: problem with sql
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: [GENERAL] Alias-Error
Next
From: "Julian North"
Date:
Subject: naming conventions constraint