left jion附件有问题为什么？

Question

SELECT a.*,b.quan1 from `user` a,
(SELECT * FROM user_main  t1 WHERE t1.`name`="dsdad")  b 
WHERE 
a LEFT JOIN b --这行这里报错，为什么呢？
ON a.id=b.id

Answer 1

SELECT a.*,b.quan1 from `user` a LEFT JOIN (SELECT * FROM user_main  t1 WHERE t1.`name`='dsdad')  b ON a.id=b.id