Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0GDTAV88316 for ; Wed, 16 Jan 2002 08:29:10 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD90557E9.dip.t-dialin.net [217.5.87.233]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id g0GDSts04405 for ; Wed, 16 Jan 2002 14:28:55 +0100 Subject: reforming query for 7.0.2 From: Markus Bertheau To: postgres sql list Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-dKs2WGNtJfcj1iHIutuo" X-Mailer: Evolution/1.0.1 Date: 16 Jan 2002 14:28:54 +0100 Message-Id: <1011187735.27679.11.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200201/179 X-Sequence-Number: 6265 --=-dKs2WGNtJfcj1iHIutuo Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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 =3D 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 --=-dKs2WGNtJfcj1iHIutuo Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA8RYAWKNEjAb345r4RAkj+AJ9IgGT1MEiVtdK5mhGf+hA90cedUwCdFQyR cIkLaotCrlnu2ORbQNd7Bo8= =NWKv -----END PGP SIGNATURE----- --=-dKs2WGNtJfcj1iHIutuo--