MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Tricky Join Problem
Posted by: Martin van Kalken
Date: November 12, 2008 11:48PM

This will work but may be a problem depending on the number of records as it will scan the entire table twice.

SELECT * FROM t1 INNER JOIN t2 ON t2.f1=LEFT(t1.f1,LENGTH(t2.f1))

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Tricky Join Problem
3004
Sameh Hammouri
October 27, 2008 09:32PM
Re: Tricky Join Problem
1848
Jose Ramon Vargas
October 28, 2008 01:20AM
Re: Tricky Join Problem
1969
Sameh Hammouri
October 28, 2008 04:27AM
Re: Tricky Join Problem
1919
Martin van Kalken
November 12, 2008 11:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.