b_test1.id
FROM tb_test1, tb_test2
WHERE TRIM(tb_test1.id)='abcde'
AND tb_test1.id = tb_test2.id
Anybody could explain this?
Thank you.
Francis
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 8:19 PM
To: 'Francis Mak '; &
Have you tried this with the latest MySQL 4.1.x build? Does it not work in
this version? What does the explain plan show?
-Original Message-
From: Francis Mak
To: [EMAIL PROTECTED]
Sent: 7/13/04 4:01 AM
Subject: Cannot do join on varchar
Hi,
I found out that when joining varchar colu
