All files are strictly confidential: all information is classified.
© Copyright 2002 - 2012 mximize.com.
All right reserved.
You can put multiple conditions in your LEFT, RIGHT and INNER/OUTER joins if you want.. below a small example that will give you the idea.
SELECT tbl.id, tblo.naam
FROM sometable tbl
LEFT JOIN someothertable tblo ON tblo.id = tbl.id
AND tblo.function = tbl.function
ORDER BY ....
Didn't know this one.. could have saved me a lotta query's in the past :-(
37312 viewed | 10 opinion(s) | del.icio.us | Digg it | Tjarko @ 01/06/05 0:00 cet
it doesnt work !! dont misguide people with such posts!
14 March 2009 16:12 cet
It works in sql server and oracle. Its probably your way of coding or your database.
14 March 2009 16:22 cet
multiple conditions on a join is commonplace...or did i miss something?
20 April 2009 15:16 cet
It does work, as long as you know what your doing.
Joining on multiple columns doesn't work properly (5.0).
Adding extra conditions does.
03 June 2009 15:10 cet
Never tried to join on multiple columns, just with extra condition, but i think also multiple columns should work.
15 October 2009 19:13 cet
Thanks for the nice post. It works for me. I dont know why it is not working for other people..anyway thanks for sharing such a nice post.
06 July 2010 6:39 cet
off couse it works
30 September 2010 4:58 cet
Already knew about this, but yeah it works. And good job telling the world about it. Suprising how many people don't know stuff like this.
10 June 2011 3:49 cet
Of course it works!I use this in SQL Server 2005/2008 and now I tried it in MySql 5+ and it works great.
Now the challenge is to get it to work in the Zend Framework Zend_Db_Select object.Tell me again why Zend needed to reinvent the wheel and put a layer on top of SQL?I put both conditions in a single string as the joinInner parameter, but it seems like it should be an array, but that doesn't work.Weird.In anyone knows PHP and the Zend Framework, some guidance would be greatly appreciated.
Thanks.
22 September 2011 4:29 cet
God I wish this would work in zend framework too. Managed to produce the select and assemble it out. Runs fine in phpmyadmin when copied in but when zend runs the same select it runs like a where clause. Any attempt to query a null fails as where clases run after the join not during by my account.
03 November 2011 19:09 cet
