pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: juerg.rietmann@pup.ch
To: pgsql-sql@postgresql.org
Subject: how to build this query ??? Please help !!!
Date: Wed, 3 Jan 2001 16:17:19 +0100
Message-ID: <OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch> (raw)

Hello there

I have a problem, building a query. Who can help ?
I use postgreSQL 7.0.3.

Thanks for any help and suggestions ... jr

orders
a_nr ¦ product ¦ state
-----------------------------
11   ¦ tp      ¦ aaaa
12   ¦ fi      ¦ bbbb
13   ¦ tp      ¦ cccc
14   ¦ ok      ¦ eeee
15   ¦ dm      ¦ aaaa

cylinders
z_a_nr   ¦     z_status
------------------------------
11     ¦  zdr
11     ¦  zdr
12     ¦  zdr
12     ¦  zcu
13     ¦  zdr
13     ¦  zcu
13     ¦  zcu
13     ¦  zcr
15     ¦  zcu
15     ¦  zcu
15     ¦  zdr

I need a query for the following output :

a_nr   ¦  #cylinder #zdr #zcu #zcr product    state
----------------------------------------------------------------------
11        2         2    0    0    dm         aaaa
12        2         1    1    0    tp         aaaa
13        4         1    2    1    fi         bbbb
14        0         0    0    0    ok         eeee
15        3         1    2    0    dm         aaaa





============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================




Message-ID: <OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch>
Permalink:  ../OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch/
Also on:    postgresql.org/message-id/OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: juerg.rietmann@pup.ch
  Subject: Re: how to build this query ??? Please help !!!
  In-Reply-To: <OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch>
  References: <OF1A29840D.F8821C77-ONC12569C9.00445CC1@pup.ch>

* 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