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