The following two similar codes which I thought same produces two different outputs.
I wonder what the different is then between them.
select personid from table1 t1
left join table2 t2
on t1.personid = t2.personid and t2.personid is null
where date between '21020801' and '20120805' and t1.personid like '95*'
second code :
select personid from table1 t1
left join table2 t2
on t1.personid = t2.personid
where date between '21020801' and '20120805' and t1.personid like '95*' and t2.personid is null