If you refere to more than one table in a query, you have to specify
which column to which table belongs. So your query must be
Select XID, xi.DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
xi.System=1 and xi.Category=c.Index
Arne.
Olle Wijk wrote:
>
> Hi,
>
> I am pretty new att
Ligia Pimentel wrote:
>
> Hello!
>
> I want to read about what I can do with ECPG, but I have just found a couple
> of examples with SELECT statements. Is there a complete documentation of
> this? Can you help me find it?
A complete documentation of what: ecpg or SQL ?
Actually you find everyth
satish rao wrote:
>
> Hi
>
> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc] [text] NULL)
>
> We need to kn
Jaydip wrote:
> Dear Friends
>
> I am Jaydip Dewanji working as a Sr. Programmer for Ontrack Systems Ltd.
>
> I have some questions regarding Postgresql which are listed below:
>
> a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a Da=
> te/DateTime variable.
>
> For
