> Hi group.
>
> I have this query:
>
> SELECT FTDLN.NID FROM FTDLN INNER JOIN FTDOC ON
> FTDLN.NTIPO = FTDOC.NTIPO AND
> FTDLN.NNUMDOC = FTDOC.NNUMDOC AND
> FTDLN.CSERIE = FTDOC.CSERIE
>
> This query in a particular database dont'n work, i.e., 0 rows return.
>
> But this query:
>
> SELECT FTDLN.NID FROM FTDLN INNER JOIN FTDOC ON
> FTDLN.NTIPO = FTDOC.NTIPO AND
> FTDLN.NNUMDOC = FTDOC.NNUMDOC AND
> FTDLN.CSERIE = FTDOC.CSERIE
> ORDER BY FTDLN.NID
>
> With the 'ORDER BY' clause alredy works.
>
> Does anybody has any ideia why this happened?
>
> Thanks a lot...
>
> Nuno Teixeira
> Portugal