On Wed, 22 May 2002, Gabriel Dovalo Carril wrote:
> Select item.item,
> max(case when property.idproperty = 0 then property.property else
> ''::text end) as p0,
> max(case when property.idproperty = 1 then property.property else
> ''::text end) as p1
> >From item, property, tlkp_item_property
> Where item.iditem = tlkp_item_property.iditem and
> tlkp_item_property.idproperty = property.idproperty
> Group by item.item;
Thanks a lot. This helped much. Any hints if there are online
documents available which do explain those problems?
Kind regards
Andreas.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
|