Re: Join 2 tables

["emmim44"]

it gives me what I want except one extra row which exists in result table.

 My updated query:

  select  i.facname
      , i.facsch
      , initcap(r.lastname) lastname
      , initcap(replace(r.firstname,' ','')) firstname
      ,  initcap(r.firstname) dspfirstname
      , r.homefac
      , i.facspot
      , i.facid
      
   from genbid_assignmentinfo i, genbid_bidresult r

 where   
    r.facsch(+) = i .facsch
    and (i.factype ='LT' and r.facname(+) = i .facname) 
 order 
    by i .facname
     , i .facsch
      , r.lastname
      , r.firstname