MySQL语句: spliting rows values into new columns

Question

使用 MySQL，我需要为 table1 中的每个用户返回新的名字/姓氏列。

**Table1**  uid  1  2  **Table2**  id   fid   uid   field_value  1    1     1     Joe  2    2     1     Blow  3    1     2     Joe  4    2     2     Blogs**Result**uid   first_name   last_name1     Joe          Blow2     Joe          Blogs

Answer 1

解决办法很简单，

select t1.uid, t21.field_value first_name, t22.field_value last_name
from table1 t1, table2 t21, table2 t22
where t1.uid=t21.uid and t1.uid=t22.uid and t21.fid=1 and t22.fid=2