🚀 go-pugleaf

----- Original Message ----- 
From: "Wayne Niddery (TeamB)" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
Sent: Monday, April 21, 2008 4:51 PM
Subject: Re: Join - understand strange results

> 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).

That's the problem, because a.abinp and a.fil are same data, passed as
parameters for table B and for test :

How can I check which caracter makes the difference ?

If I  try :
------------------------------------------------------------------------------------
select distinct  a.abinp, a.fil, b.abinp, b.fil, b.ambname, b.filname
from giocoge a
left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, 'ABIT', 'DETO') b
on (b.abinp = 'ABIT' and b.fil = 'DETO' )
where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
'DETO'

OR

select [..]
left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc,  'ABIT', 'DETO')
b
on (b.abinp = a.abinp and b.fil = a.fil )
where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
'DETO'

 I get  right data:
ABIT   DETO    ABIT    DETO    XX1     YY1
---------------------------------------------------------------------------------------
select [..]
left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, a.fil) b
on (b.abinp = a.abinp and b.fil = a.fil )
where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
'DETO'

I get
ABIT   DETO    null null null null


Could you give me an help ?
Thanks
Adalberto