reforming query for 7.0.2

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: reforming query for 7.0.2
Date: 2002-01-16 13:28:54
Message-ID: 1011187735.27679.11.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

how do I reform this query to work with 7.0.2?

select * from personen join (select count(personen_id), personen_id from
orders group by personen_id) as ordertemp on personen.personen_id =
ordertemp.personen_id

If the table structure is needed I will happily post it here. Although I
don't think it is.

TIA

Markus Bertheau

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Boes 2002-01-16 13:38:28 Re: Long-running DELETE
Previous Message Koen Antonissen 2002-01-16 12:55:18 Count Total on a limited query?