SELECT; Test1.c1, Test2.c2 AS max_code; FROM Test1 ; LEFT OUTER JOIN Test2 ; ON Test1.c1=ALLTRIM(Test2.c2); OR 'X'=ALLTRIM(Test2.c2)But now I'm in trouble to understand why. Also I do
SELECT; Test1.c1, Test2.c2 AS max_code,; Test1.c1=ALLTRIM(Test2.c2),'X'=ALLTRIM(Test2.c2); FROM Test1 ; LEFT OUTER JOIN Test2 ; ON Test1.c1=ALLTRIM(Test2.c2); OR 'X'=ALLTRIM(Test2.c2)As supposed 'X'=ALLTRIM(Test2.c2) is always .F. except for "grau" and "will".
SELECT; Test1.c1, Test2.c2 AS max_code,; Test1.c1=ALLTRIM(Test2.c2),'X'=ALLTRIM(Test2.c2); FROM Test1 ; LEFT OUTER JOIN Test2 ; ON Test1.c1=ALLTRIM(Test2.c2) * ; * OR 'X'=ALLTRIM(Test2.c2)- all from Tests is .NULL. again.