Re: Tablenames in Resultsets? - Mailing list pgsql-general

From Papp Gyozo
Subject Re: Tablenames in Resultsets?
Date
Msg-id Pine.GSO.4.21.0009271310010.18676-100000@ural2
Whole thread Raw
In response to Tablenames in Resultsets?  (gb@a3design.de)
List pgsql-general
Hi,

instead of
> select * from test1, test2 where test1.id=test2.id
use

SELECT test1.id AS "test1.id", test1.value, test2.id AS "test2.id",
test2.value FROM test1 , test2 WHERE test1.id = test2.id;

Papp Gyozo

s7461pap@hszk.bme.hu, gerzson17@freemail.hu





pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: problem creating template database
Next
From: Thomas Good
Date:
Subject: Re: Re: web programming