RE: MySQL outer join with substring_index() function

2004-01-29 Thread Nathan Christiansen
x(t2.weird, '-', -1) ) where t1.key = and t1.id = t2.id; -- Nathan Christiansen > -Original Message- > From: Nathan Christiansen > Sent: Thursday, January 29, 2004 3:49 PM > To: [EMAIL PROTECTED] > Subject: MySQL outer join with substring_

MySQL outer join with substring_index() function

2004-01-29 Thread Nathan Christiansen
I am having a terrible time trying to understand the outer join syntax for MySQL (Our sever version is: 3.23.56). I have three tables I want to join two of which by inner joins and the other by an outer join. Here are my example tables: table1: +--+--+ | id | key | +--+--+ | 4