Re: Question Join/Subselect

On Wednesday 27 August 2003 10:28 pm, Alex wrote:
> Hi,
>
> I have some problems with creating a query that will replace values in
> one table from another one.
>
> Table 1:
> userName : refCode1 : refCode2
> ------------------------------
> alex : 12 : 24
>
> Table 2:
> refCode : ActualCode
> ---------------------
> 12 AAAAAA
> 24 BBBBBB
>
>
> Result Desired
> userName : refCode1 : refCode2
> ------------------------------
> alex : AAAAAA : BBBBBB
>
>
> I need to crete a view that returns me Table1 but replaces refCode1,
> refCode2 with the ActualCode.
>
> I did not have any success with Joins or Subselects so far.
>
> Thanks for any advise
>
> Alex

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;

I hope this helps,

Andrew Gould