Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I extract ONE particular field, when multiple table - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: How do I extract ONE particular field, when multiple table
Date
Msg-id Pine.BSF.4.31.0109142232500.26062-100000@tb303.partitur.se
Whole thread Raw
In response to How do I extract ONE particular field, when multiple table contain the same field name?  (olle.wijk@systecon.se (Olle Wijk))
List pgsql-sql
Tree view 
What you want to know is probably this:

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

Regards,
Patrik Kudo

pgsql-sql by date:

Previous
From: Richard NAGY
Date:
Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3
Next
From: "Josh Berkus"
Date:
Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3