php - 我正在尝试从行中获取数据以匹配定义的列

Question

使用 PHP/MySQL

我有两个表，一个是customers，另一个是cust_data

有一个字段匹配这两个它是ListID

现在在 cust_data 表中，数据列为 cust_data

列:

ListID  DataName  DataValue
 1      type      something
 1      Region    something

客户列:

ListID Name Address City State Zip Phone

我想得到的结果是

Name Address City State Zip Phone Type Region

Answer 1

SELECT customers.*, data_type.DataValue AS Type, data_region.DataValue AS Region
FROM   customers
  JOIN cust_data AS data_type ON (
         data_type.ListID   = customers.List_ID
     AND data_type.DataName = 'Type'
  )
  JOIN cust_data AS data_region ON (
         data_region.ListID   = customers.List_ID
     AND data_region.DataName = 'Region'
  )