On Wed, Feb 19, 2003 at 15:25:41 +0100, Axel Schlueter <axel@pqrs.de> wrote:
>
> When doing the following select statement:
> select * from a,b where a.objid=b.objid
> postgresql returns four columns labeled
> objid atext objid atext
> instead of what I expected:
> a.objid a.atext b.objid b.atext
Use something like:
select a.objid as "a.objib", a.atext as "a.atext", b.objid as "b.objid", b.atext as "b.atext" from a,b where
a.objid=b.objid;