Please help me in this Query

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
PortugalNuno Teixeira wrote:
> 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
Are any of those columns NULLable? If so,make sure to include a WHERE
ColName IS NOT NULL to the query and then try them again.
David Gugick
Quest Software
www.imceda.com
www.quest.com