LEFT JOIN Optimisation!
I have the following query:
I can't see anything wrong with the syntax however whenever I execute it I get a 500 Internal Server Error back from phpMyAdmin.
SELECT orders.*, order_lines.*
WHERE DATE(orders.timestamp) BETWEEN '2009-04-01' AND '2009-06-30'
LEFT JOIN order_lines
ON orders.txn_id = order_lines.transaction_id
ORDER BY orders.timestamp ASC
Firstly, is the syntax of this query correct?
Secondly, can it be optimized to perform correctly?
I think the JOIN has to come before the WHERE.
Yes, the WHERE should be the last thing before the ORDER BY in that query.
Originally Posted by triassic
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)