Hello,
I'm using MaxDB 7.5.00.15 on WinXP.
I have created temporary table using statement like this:
CREATE TABLE TEMP.SOME_NAME AS SELECT ...
When I execute:
SELECT COUNT(SOME_NAME.ID) FROM TEMP.SOME_NAME JOIN OTHER_TABLE ON ...
I get correct results.
But when I execute with RIGHT JOIN:
SELECT COUNT(SOME_NAME.ID) FROM TEMP.SOME_NAME RIGHT JOIN OTHER_TABLE ON
...
I get as many rows as there are in table OTHER_TABLE and all of them filled
with zeros (0).
Is it intended behaviour or something is wrong with database ?
Regards,
Donatas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
