0

Possible Duplicate:
MySQL pivot table

SQL Transpose Help needed

I need help transforming a table with 3 columns and 2 rows into a table with 4 columns and 1 Row

vvvvv
  • 25,404
  • 19
  • 49
  • 81
Saumil Shah
  • 1,383
  • 2
  • 11
  • 20
  • 3
    That'd be a pivot table, and they're not directly supported by MySQL. you're better off doing that transformation in your client app. They CAN be done in SQL, but the queries are extremely ugly and do not scale easily if you need to add more fields. – Marc B Apr 10 '12 at 19:16
  • @Marc B, can you provide an example? I'm not going to have more fields. This is pretty much it. Example would be helpful. – Saumil Shah Apr 10 '12 at 19:18

0 Answers0