This problem has got me stumped for a while now...
I have several tables, and I want:
TableX.one as a1, TableX.two as a2 WHEN TableX.three = '1'
TableX.one as b1, TableX.two as b2 WHEN TableX.three = '2'
There are other values for TableX.three, but I only want the rows where it's 1 or 2...