Jump to content


Photo

Joins pbm


  • Please log in to reply
No replies to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 26 October 2005 - 06:17 AM

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users