Order in left join

Hello everyone,

i have a simple question:
is order of fields in (left) join in MAXDB significant?

For example:

select * from "Table1"
left join "Table2" on "Table1_ID"="Table2_IDTable1"

Returns:
10	21	10	
11	?	?	

but

select * from "Table1"
left join "Table2" on "Table2_IDTable1"="Table1_ID"

Returns:
?	20	?	
10	21	10

I get confused.
Two diffrent strategies (JOIN VIA KEY RANGE/JOIN VIA KEY COLUMN).

I have searched bugs.mysql.com but it gets nothing.
Is it bug whether my basic mistake?

Lukasz

---------------------
MAXDB 7.6.00.37 WinXp prof., test data:

CREATE TABLE "Table1"
(
	"Table1_ID"  Fixed (12,0),
	PRIMARY KEY ("Table1_ID")
)
//
CREATE TABLE "Table2"
(
	"Table2_ID"  Fixed (12,0),
	"Table2_IDTable1"  Fixed (12,0),
	PRIMARY KEY ("Table2_ID")
)
//
insert into "Table1" values (10)
//
insert into "Table1" values (11)
//
insert into "Table2" values (20,null)
//
insert into "Table2" values (21,10)
//
select * from "Table1"
left join "Table2" on "Table2_IDTable1"="Table1_ID"
//
select * from "Table1"
left join "Table2" on "Table1_ID"="Table2_IDTable1"


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]