Re: no self-joins in views?

On Thu, Feb 10, 2005 at 05:13:51PM +0100, Christoph Pingel wrote:
>
> is there any restriction re the use of self joins in views? I have a
> moderately complicated query where I scan the same table twice using
> aliases, and I would like to put that into a view to keep my python
> code clean. However, I get an error 'column xy duplicated'. Is this
> so by design?

Use column aliases so the xy columns don't have the same name:

CREATE VIEW viewname AS
SELECT a.xy AS axy,
       b.xy AS bxy
FROM foo AS a,
     foo AS b
WHERE ...

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/