Hi everyone, I just joined this list a few days ago...
Now, I have a question, and I'm not even sure if this is possible
without having to make numerous statements.
Say I have two tables with the following columns and this data:
types:
id | name
-----------------
1 | first_name
2 | last_name
3 | phone_number
data:
id | data | t_key | cust_id
---------------------------------
1 | Sam | 1 | 1
2 | Smith | 2 | 1
3 | 555-1212 | 3 | 1
4 | John | 1 | 2
Types basically describes what the column type is. t_key references the
type, cust_id is the user id.
i'd want to do something like "select t.name, d.data from types t, data
d where d.cust_id = 1"
This would return something like:
name | data
------------------------
first_name | Sam
last_name | Smith
phone_number | 555-1212
Well, I need it to somehow return that data in this format:
first_name | last_name | phone_number
----------------------------------------
Sam | Smith | 555-1212
The information in Types is not static, so I can't declare the col names
based on what you see here.
Any suggestions on this one?