我有三张桌子(product
, product_description
, product_store_description
).
product
该表有一行
+----------+---------------------+
|product_id| description |
+----------+---------------------+
| 1 |'regular description'|
+----------+---------------------+
产品描述
该表有零行
+----------+-----------+--------+
|product_id|description|language|
+----------+-----------+--------+
产品商店描述
This table has zero rows
+----------+-----------+--------+--------+
|product_id|description|language|store_id|
+----------+-----------+--------+--------+
我想退回.description
所有表的列WHERE product.product_id = '1'
.
所以在这种情况下我想要的输出是
$row = $result->fetch_assoc();
echo '<pre>';
var_dump($row);
echo '</pre>';
array (size=3)
'p_description' => string 'regular description' (length=19)
'pd_description' => string '' (length=0)
'psd_description' => string '' (length=0)
我已经尝试了 SQL 的许多变体,这就是目前的情况。
SELECT p.description AS p_description ,pd.description AS pd_description, psd.description AS psd_description FROM product AS p
RIGHT JOIN product_description AS pd ON(pd.product_id = p.product_id)
RIGHT JOIN product_store_description AS psd ON(psd.product_id = p.product_id)
WHERE p.product_id = '1'
AND pd.language = 'en'
AND psd.language = 'en' AND psd.store_id = 1;
这将返回零行
我寻找了一个答案,这导致我使用RIGHT JOIN
但这并没有解决我的问题。
我创建了一个 SQL 小提琴HERE不幸的是,我还没有能够得到任何人的工作答案。