SQL Select Query problems
Posted on 2016-10-11
in a table I got columns values Code, Desc01, Desc02, Desc03, Desc04 up to 15
in another table, I got columns: Code, Qty01, Qty02, Qty03, Qty04 ... all to Qty15.
my question is, I need to read the second table but I dont want to show in headers Qty01 Qty02 ..
I want to show the real description based on the "Code value"
if code is R1
Desc01 to 15 will be let's say: XXS, XS, S, M, L, XL, XXL, XXXL
if R2 it could be: 0 2 4 6 8 10 12 14 16
i want to show the good QTYS on the real description, without showing "Qty01" "Qty02" you know what I mean ?
can you help on this,.. ?