php子选择错误

php子选择错误 - 无论如何还要在这里进行LEFT JOIN吗？(error with php subselect - Is there anyway to do a LEFT JOIN here instead? [closed])

这个SUBSELECT出错了吗？

$common_dimensions_query = " SELECT * FROM main_products_common_dimensions d WHERE d.product_id = (SELECT id FROM main_products WHERE abbreviation = '".$product."'";

错误：

警告：pg_query（）[function.pg-query]：查询失败：错误：输入结束时的语法错误LINE 4：...（SELECT id FROM main_products WHERE abbreviation ='banner' ^ in

反正在这里做LEFT JOIN吗？

I get an error with this SUBSELECT?

$common_dimensions_query = " SELECT * FROM main_products_common_dimensions d WHERE d.product_id = (SELECT id FROM main_products WHERE abbreviation = '".$product."'";

The error:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input LINE 4: ... (SELECT id FROM main_products WHERE abbreviation = 'banner' ^ in

Is there anyway to do a LEFT JOIN here instead?

最满意答案

使用JOIN而不是双SELECT的版本：

"SELECT * FROM main_products_common_dimensions d JOIN main_products p ON d.product_id = p.id WHERE p.abbreviation = '$product'"

A version with JOIN instead of double SELECT:

"SELECT * FROM main_products_common_dimensions d JOIN main_products p ON d.product_id = p.id WHERE p.abbreviation = '$product'"