MYSQL在多表联合查询时,使用left join出现Unknown column ‘xxxxx‘ in ‘on clause‘错误的一次排查

关键表结构:

sender,发货人信息表

salebill,销售信息表

salebillDetail,销售明细表

 

在联合查询时,错误的源码是:

SELECT
	s.UserId,
	s.SenderId,
	s.BuyerId,
	s.buyernick,
	s.Receiver_Name,
	s. STATUS,
	s.Closed,
	d.id,
	d.salebillid,
	d.itemid,
	d.count,
	d.`name`,
	ifnull(i.incount, 0) AS incount,
	IFNULL(o.outcount, 0) AS outcount,
	(
		ifnull(outcount, 0) - ifnull(incount, 0)
	) AS need
FROM
	salebill s,
	salebilldetial d
LEFT JOIN (
	(
		SELECT
			outstockbilldetial.itemid,
			ifnull(
				sum(outstockbilldetial.count),
				0
			) AS outcount
		FROM
			outstockbilldetial,
			outstockbill
		WHERE
			outstockbill.userid = 10000
		AND outstockbill.Time > (
			SELECT
				max(CreateTime)
			FROM
				ventorycheckbatch
		)
		AND outstockbill.Canceled = 0
		AND outstockbill.OutStockBillId = outstockbilldetial.OutStockBillId
		GROUP BY
			itemid
	) AS o
) ON o.itemid = d.itemid
LEFT JOIN (
	SELECT
		instockbilldetial.itemid,