var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: syntax error
i'm trying to execute the folloowing query
SELECT StoreName, ARIAnetID, ID
NOT IN (SELECT ID FROM received_stores WHERE Date BETWEEN '2003-09-12 00:00:00' AND '2003-09-12 23:59:59')
but i keep on getting
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ID
if i separate the 2 queries they execute ok but together they don't. looked through all the examples and i could find and i couldn't see anything obvious i was doing wrong. help?
seems an obvious question, but... what version of mysql are you using?
subselects are only available from version 4.1+
This should do what you're after:
store_info AS info
received_stores AS received
info.ID = received.ID
received.Date BETWEEN '2003-09-12 00:00:00' AND '2003-09-12 23:59:59'
received.ID IN NOT NULL