Re: Question Join/Subselect

Thanks for the help.
Alex

Richard Huxton wrote:

>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;
>>>
>>>
>
>
>