🚀 go-pugleaf

"Adalberto Baldini" <finman@swissonline.ch> wrote in message 
news:480c85b4$1@newsgroups.borland.com...
>
> from giocoge a
> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, a.fil) 
> b
> on (1=1)

This is exactly the same as:
    select [...]
    from
      giocoge a,
      ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, a.fil) b

It is a cartesian join, meaning every row from b will be matched with every 
row from a. E.g. if there are 3 rows returned by both a and b, then this 
query will produce 9 rows.

> if I change join in :
>
> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, a.fil) 
> b on (a.abinp = b.abinp and a.fil = b.fil  )  ....
>
> I get  :
> ABIT   DETO    null    null    null    null
>
> Why I loose joined data in 2nd row?
> comparison is done on same data passed as parameters.

Because you are now requiring a match between fields. Apparently, for the 
above row, there is no matching record returned by the stored procedure (no 
match on abinp or fil fields). If you change "left" to "inner", this record 
will not show up at all. "Left" requires all records from a to be returned 
even if no match in b, but in that case, b's fields will be returned as 
null.

-- 
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)