I havd had the experience that using WHERE statements returns zero rows when one of the conditions is false. A JOIN statement returns the cells in a row that exists... Somehow like that. Meaning that a WHERE statement stops lokking for rows if it encounters one that does not match the search critera, and JOIN's continue until the end of the table.
2 2004-01-14 13:49
Re: Mysql INNER JOIN Error (7 replies, posted in PunBB 1.2 troubleshooting)
It is possible to rewrite the sql statements into 2 or three separate statements. However, this invloves much time to understand the database structure.
Lucky for me, my ISP just installed a new MySQl database (4.x) so problem solved for me. It is one of them greedy german providers. It is very slow and they are called Strato (www.strato.de). To every one reading this: STAY AWAY FROM STRATO! THEY SUCK BIG TIME. ALSO STAY AWAY FROM FSDATA (www.fsdata.se) THEY ARE REAL GOOD BUT REAL EXPENSIVE TOO (150 kr /månad)
Over n Out
Thanks for a clean forum 
Hate massive phpbb
3 2004-01-14 02:59
Topic: Mysql INNER JOIN Error (7 replies, posted in PunBB 1.2 troubleshooting)
Hi,
My ISP uses MySQL 3.22.32 and according to the documentation this version does not support INNER JOIN. This seem pretty crucial for this forum to work. Please give me a fix...
Iget these kind of error statements:
punbb/viewtopic.php
Line: 99
PunBB reported: Unable to fetch topic info
Database reported: You have an error in your SQL syntax near
'INNER JOIN mlt_forum_forums AS f ON t.forum_id=f.id
LEFT JOIN mlt_forum_subscrip' at line 1 (Errno: 1064)