Sql Query

[angah_long 0]

salam..

mohon bantuan otai2 dalam menyelesaikan permasalahan ini...kenapa bile execute je both query ni menghasilkan result yang berbeza2..?

select s.studentstatus, s.studentid, s.hutang, a.success, s.blacklist, a.cancel,semestercode

from student s, apartmentapplication a

where s.studentid = 'AA1235'

and s.studentid *= a.studentid

and a.cancel =0

and a.semestercode = '2008/9s1'

select s.studentstatus, s.studentid, s.hutang, a.success, s.blacklist, a.cancel,semestercode

from student s left join apartmentapplication a on s.studentid = a.studentid

where s.studentid ='aa1235'

and a.cancel = 0

and a.semestercode = '2008/9s1'

[sworn 0]

*= tu adik bradik ngan left join kan?

beza kat 'AA1235' ngan 'aa1235' je,kan?

ke aku silap nih?

ape beza output yg ko ckp tu?