Joins pbm

[shan_cool]

Hi all,

i hav a pbm while executing the following query.

 

select a.Emp_FName from HR_Emp_Det a,tdm_prj_mem_det b, where a.Emp_Id = b.Emp_Id and b.Emp_Id='1111'

 

but if i execute as,

select a.Emp_FName from HR_Emp_Det a,tdm_prj_mem_det b, where a.Emp_Id = b.Emp_Id ..... thn its working properly.

 

plz help me wats wrong wit the first one.

 

thx in advance,

shan,

chennai

india