On Tue, 9 Mar 2004, Richard Grosse wrote:
> Trying to convert the query below to a view. The problem is > despite it working as a query when trying to save it as a > view the database returns the error that the field tablealias.cmpname > is duplicated. (Which it is and has to be)
You're going to need to use column aliases to alias (for example) tbldeliver.cmpname, tblsender.cmpname, tblhaulier.cmpname to different aliases in the view, perhaps "tbldeliver.cmpname" "tblsender.cmpname" and "tblhaulier.cmpname" (note the double quotes).
Great just what I needed to know. Works fine now :-)
Thanks
Richard
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
