一次将两个属性拿出,该如何处理

一次将两个属性拿出
<?php 
include("conn.php");
$rs=mysql_query("
SELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id 
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =31 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_values

union

SELECT products_des_options_values.options_values
FROM products_des_options_values
JOIN products_des_attributes ON products_des_options_values.id = products_des_attributes.products_des_options_values_id
JOIN products ON products.id = products_des_attributes.products_id 
join products_des_options on products_des_options.id = products_des_attributes.products_des_options_id
WHERE product_type='41' and STATUS !='D' and products_des_options.id =35 and ppcode like '%ACK2804N%'
order by products_des_options_values.options_values ");

while($row=mysql_fetch_array($rs) and $row2=mysql_fetch_array($rs2))
{ 
echo $V="$row[options_values]<br/> ";
echo $A="$row2[options_values]<br/>";
echo $V * $A."<br/><br>";
}
 

?>

我在phpmydamin下运行，老是报错：#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT options_values FROM products_des_options_values JOIN products_des_attribu' at line 2




[解决办法]
鉴于你的表名比较长。建议查询时为每个表起个别名。然后查询列和条件加上别名。

合并的话。用in 或者or 或者union all 都可以。