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 duplicated. (Which it is

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

2004-03-09 Thread Stephan Szabo
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