Re: [SQL] Converting query to view - duplicate fields - solved

2004-03-10 Thread Richard Grosse
At 02:17 10/03/2004, you wrote: 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 duplicate

[SQL] Converting query to view - duplicate fields

2004-03-09 Thread Richard Grosse
Hello, 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) So how to a refer to the same table more than once and get