|
Hello,
Would someone know why this 2 SQL fail
:
Select * from T1, T2, T3 where T1.id = T3.idt1 and T3.idt2
=T2.id into Selection
Select * from T3, T1, T2 where T1.id = T3.idt1 and T3.idt2 =T2.id into Selection and
why these two work :
Select * from T1, T3, T2 where T1.id = T3.idt1 and T3.idt2 =T2.id into Selection Select * from
T2, T3, T1 where T1.id = T3.idt1 and T3.idt2 =T2.id into
Selection
T3 being the "main" table, storing integer ids idT1 and
idT2, refering to Table1 and Table2
The only difference in these 4 SQL is the order of T1,
T2, T3 in the "from" clause
I must say, my collegue and myself are a bit
puzzled...Is there some kind of implicit or explicit SQL rules I've never heard
of (after all, I'm not an SQL expert) or is it just mapinfo being funny
?
David HILPIPRE
|
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
