what is the difference between '=' and '*=' when we establish relationship between tables
because when i execute
Select e.name as Name, e.address as Address,d.deptname as Department
from emp e ,dept d
where e.deptid *= d.deptid
and ( e.name like 'a%' )
then along with the records where name starts with 'a' , i also get the records with name blank
But ,when i execute the following sql command ,i only get the records where name starts with 'a'
Select e.name as Name, e.address as Address,d.deptname as Department
from emp e ,dept d
where e.deptid = d.deptid
and ( e..name like 'a%' )