Re: Question Join/Subselect

On Thursday 28 August 2003 08:20, Alex wrote:
> Andrew,
> thanks for the help. The query actually works. However if I try to
> create a view then the sever complains
>
> Create Tabe: attribute "actualcode" duplicated;

Alias the output names:
... Table2.ActualCode as actual1, Table3.ActualCode as actual2 ...

> Any Ideas on how to get around that ?
>
> Alex
>
> Andrew L. Gould wrote:
> >On Wednesday 27 August 2003 10:28 pm, Alex wrote:
> >
> >I'm not sure how to handle the space in the table names.  If there weren't
> > any spaces in table names, the following should work:
> >
> >select Table1.userName, Table2.ActualCode, Table3.ActualCode
> >from Table1, Table2, Table2 as Table3
> >where Table1.refCode1 = Table2.refCode and Table1.refCode2 =
> > Table3.refCode;

--
  Richard Huxton
  Archonet Ltd