[RESOLVED] Left join problems

[ledtear]

In this query:

SELECT * FROM table1 where table1.field1 > CURDATE() and (table1.field2 = '16' or table1.field3 = '16')
LEFT JOIN table2
ON table2.field4 = table1.field4

Is there a problem with having a where clause? It does not work with the where but does without - if so, how would i incorprate the where?

[Piranha]

It is no problem having both joins and where clauses, and you can have many other clauses as well. But they have to be in the right order, as seen in the manual.