SQL statement help on poorly designed database

[jaybuffet]

I am working on a site that is in production, so I can't change the tables. The way it is nowI have 3 tables.

1. tblNumbers

num
---
 1
 2
 3

2. tblImpacts

num     a     b     c
----------------------
 1      1     0     1
 2      0     1     1
 3      1     1     1

3. tblImpactDecode

code     decode
---------------
  a       'this is a'
  b       'this is b'
  c       'this is c'

So I have to make a statement that does an inner join on the tblImpact columns = tblImpactDecode.code

So if I select tblNumbers.num = 1
the results would be

num     decode
 1       'this is a'
 1       'this is c'

is there a SQL statement or a stored procedure

please help

thanks
jason

 

[MonsterBuck]

I thought of the Union statement...
Something like this:

select num, decode
from tblimpacts
inner join tblImpactDecode
on code = 'a'
where a = 1
and num = 1
union
select num, decode
from tblimpacts
inner join tblImpactDecode
on code = 'b'
where b = 1
and num = 1
union
select num, decode
from tblimpacts
inner join tblImpactDecode
on code = 'c'
where c = 1
and num = 1

Not sure if that works for you or not.

 

[jaybuffet]

That would work., but I was looking for more of a dynamic solution since there could be up to 15 columns