left join + where 的问题

[lunyx]

我的问题是这样的,把T1,T2通过左连接后，只查询T1.meter_no="2"，如果T2没有相关匹配，则T2.meterName='',可是语法不对，
select T1.*,T2.meterName from T1 left join T2 on T1.meter_no= T2.meter_no where T1.meter_no="2"

大侠救我

[SQL77]

select T1.*,ISNULL(T2.meterName,'')
 from T1 left join T2 on 
T1.meter_no= T2.meter_no  AND T1.meter_no='2'


select T1.*,ISNULL(T2.meterName,'')
 from T1 left join T2 on 
T1.meter_no= T2.meter_no  WHERE T1.meter_no='2'

[-狙击手-]

where T1.meter_no="2"
--
where T1.meter_no='2'

[lunyx]

wo kao ,原来是自己把meter_no=‘2’，写成了meter_no="2"