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'"更多推荐
发布评论