mysql循环查询问题

[zhengyixin1202]

大家先请看以下sql代码
-------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT A.*, (
SELECT
CASE
WHEN tb2_1.Guidk IS NULL THEN
'false'
ELSE
'true'
END
FROM
ims_warehouseOperation AS tb1_1
LEFT JOIN ims_warehouseRights AS tb2_1 ON tb2_1.OGuidk = tb1_1.Guidk

WHERE
tb1_1.Guidk = 'bb71ffcf-1dff-40c9-94c3-60680b0bb427'
) AS 'w_1',
(
SELECT
CASE
WHEN tb2_1.Guidk IS NULL THEN
'false'
ELSE
'true'
END
FROM
ims_warehouseOperation AS tb1_1
LEFT JOIN ims_warehouseRights AS tb2_1 ON tb2_1.OGuidk = tb1_1.Guidk
AND tb2_1.WGuidk = A.Guidk
WHERE
tb1_1.Guidk = '2ad84691-5819-4a66-a47d-2833dc76ee72'
) AS 'w_1',
(
SELECT
CASE
WHEN tb2_1.Guidk IS NULL THEN
'false'
ELSE
'true'
END
FROM
ims_warehouseOperation AS tb1_1
LEFT JOIN ims_warehouseRights AS tb2_1 ON tb2_1.OGuidk = tb1_1.Guidk
AND tb2_1.WGuidk = A.Guidk
WHERE
tb1_1.Guidk = '41d36e8d-b45b-4ca7-a8d1-d5738fa49297'
) AS 'w_1',
(
SELECT
CASE
WHEN tb2_1.Guidk IS NULL THEN
'false'
ELSE
'true'
END
FROM
ims_warehouseOperation AS tb1_1
LEFT JOIN ims_warehouseRights AS tb2_1 ON tb2_1.OGuidk = tb1_1.Guidk
AND tb2_1.WGuidk = A.Guidk
WHERE
tb1_1.Guidk = '4faae2db-1cc0-4b33-adcc-1a81b8be8280'
) AS 'w_1',
(
SELECT
CASE
WHEN tb2_1.Guidk IS NULL THEN
'false'
ELSE
'true'
END
FROM
ims_warehouseOperation AS tb1_1
LEFT JOIN ims_warehouseRights AS tb2_1 ON tb2_1.OGuidk = tb1_1.Guidk
AND tb2_1.WGuidk = A.Guidk
WHERE
tb1_1.Guidk = '20737a56-f75c-4f21-b1cb-855620835e19'
) AS 'w_1'
FROM ims_warehouse AS A
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
程序主要想得到这样子的效果

可是这种写法mysql不支持，会报这样子的错误 1054 - Unknown column 'A.Guidk' in 'on clause'。求大神们帮我修改修改，谢谢！！

[致命的西瓜]

把 A.Guidk的条件放在ｗｈｅｒｅ后面就可以了