join on and条件查询

on 后面加限定条件用and链接，只能对主表生效：如，

SELECT
	* 
FROM
	a
	LEFT JOIN b ON a.id = b.aid 
	AND a.NAME = 'aname'

这样的话 and 条件不生效，
正确的应该为：

SELECT
	* 
FROM
	a
	right JOIN b ON a.id = b.aid 
	AND a.NAME = 'aname'
	或者
	SELECT
	* 
FROM
	a
	LEFT JOIN b ON a.id = b.aid 
	AND b .NAME = 'aname'

只能这样写