有四张桌子。我想用当前ID链接所有表。如果查询中的最后一个表中没有值,则数据不会返回。我想访问所有表中的数据。我该怎么做呢?
我的代码:(部分工作)
SELECT
U.id AS id,
U.amount AS amount,
A.commission AS commission,
I.power AS item_power
FROM affiliate AS A
INNER JOIN users AS U
ON A.owner_id = U.id
INNER JOIN users_booster AS B
ON U.id = B.userid
INNER JOIN auction_item AS I
ON B.item_id = I.id
WHERE
A.partner_id = '1947' AND
I.type = 'reference_booster' AND
B.end_time >= NOW()
GROUP BY I.type