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
============================================