使用了下面的语句查出了数据 是正确没问题的,但是需要把里面的内容插入到另一个表格,因为是行转列的数据,无法在select后面提取到。。
Select a.orderid,a.name,a.address,a.createtime,
MAX(CASE b.field_en_name WHEN 'receive_linkphone' THEN b.field_value ELSE 0 END ) as 'receive_linkphone',
MAX(CASE b.field_en_name WHEN 'pay_info' THEN b.field_value ELSE 0 END ) as 'pay_info',
From shopping_order_main a
Left Join shopping_order_value b On a.orderid = b.orderid
where a.orderid='1568793369_xxxxxx' and
Group by a.orderid
希望提取到receive_linkphone和pay_info的数据
恳请各位大神支支招!