Re: How do I extract ONE particular field, when multiple table

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Olle Wijk <olle(dot)wijk(at)systecon(dot)se>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How do I extract ONE particular field, when multiple table
Date: 2001-09-14 20:34:43
Message-ID: Pine.BSF.4.31.0109142232500.26062-100000@tb303.partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

What you want to know is probably this:

Select XID, xi.DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
xi.System=1 and xi.Category=c.Index

Regards,
Patrik Kudo

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christof Glaser 2001-09-14 21:05:21 Re: How do I extract ONE particular field, when multiple table contain the same field name?
Previous Message David. E. Goble 2001-09-14 19:36:36 I could do with some guidance