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

please help me

hi
can anyone help me in explaining join in sql server
what is join , inner join and outer join
is there any join
what the difference between them
pls let me know
sample code will help to teach me fine
thank you in advance
regards
ramesh

(1) Books on line
(2) Google.|||

hi
Good joke
i dono haaaaaaa haaaaaaa......