Unanswered: extracting data from a multifield column
This is my first post and I think I know all the rules... and possibly have a good question.
I am trying to extract some data from a SQL database at work and have run into a multifield column that is like what follows:
pkid action userID multifield_1 Multifield_2
12 1 22 233 4
13 1 22 234 4
14 2 23 12 Blue
In this case, if action is set at 1 I get information on pkid 12 about multifield 1 being 233 and multifield 2 being 4, etc I understand this.
If I select for action 2, I get a separate group of data to include multifield2 showing blue, etc. Again, no problems.
Where my tiny head cannot comprehend and gets confused is if I wanted to get data on pkid 14, action 2, but instead of getting "12" or "blue" instead have the "12 link back to the pkid two lines up and return results "233" and "4."
Well I know they are superfluous in my usage because I do not use names that require escaping, but it's a habit I got in to because I found that it makes it easier to "spot" aliases. I previosuly used single-quotes, but found that this could be misleading, hence the switch.