I'm combining these 3 tables into a report query with INNER JOINs (this is a simplified example):
USERS
ID NAME CODE1 CODE2
1 James c1_2 c2_3
2 Bob c1_3 c2_1
C1
CODE1 VALUE
c1_1 interested
c1_2 maybe
c1_3 not interested
C2
CODE1 VALUE
c2_1 prepared
c2_2 self-study
c2_3 novice
The query result looks like this:
NAME INTEREST PREPARED
James maybe novice
Bob not interested prepared
I would like to get rid of the lookup tables and create this query result using only the USERS table and probably some clever REPLACE() statement. Can it be done?
Thank you!