Try add UNION ALL instead of UNION

-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]
On Behalf Of Erik Kurz
Sent: 10 September 2004 11:47
To: informix-list@iiug.org
Subject: different results in select ?


hi,

i get different results executing following selects: additional
information -> tab3 has no records!

1) SELECT tab1.*,tab2.*,'E11','EXP',
FROM tab1,tab2,
WHERE fakturen_nr = '123456',
AND tab2.rowid = tab1.id_leistungsart
result (3 records): tab1.*,tab2.*,E11,EXP
tab1.*,tab2.*,E11,EXP
tab1.*,tab2.*,E11,EXP

2) SELECT tab1.*,tab2.*,'E11','EXP',
FROM tab1,tab2,
WHERE fakturen_nr = '123456',
AND tab2.rowid = tab1.id_leistungsart,
UNION
SELECT tab3.*,tab2.*,'I10','IE',
FROM tab3,tab2,
WHERE fakturen_nr = '123456',
AND tab2.rowid = tab3.id_leistungsart
result (1 record !!!): tab1.*,tab2.*,E11,EXP

can anyone explain me this different results ?
is this a bug or is it just my mistake ?

thanks
erik



sending to informix-list