It depends on what's in the datetime column. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Something like this: select store.storeid, store.stName from store left outer join transaction on(store.storeid = transaction.storeid) where transaction.created IS NULL and store.active = 'yes' and date(transaction.created)=date(curdate()) group by store.storeid; -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 6:22 PM To: [EMAIL PROTECTED] Subject: how to tell if something hasn't happened yet Good day gurus and gurettes! I have a table; | transactionid | int(11) | NO | PRI | | auto_increment | | username | varchar(32) | NO | | | | | storeid | varchar(6) | NO | | | | | action | int(4) | NO | | | | | code | int(2) | NO | | | | | ipAddr | varchar(32) | NO | | | | | created | datetime | NO | MUL | | | | created_by | varchar(32) | NO | | | | I used to have a query (I have misplaced it somehow) where I could tell which storied had not logged in (created) today yet. No matter how hard I try I cannot remember the query. What I need is a query that will tell me at any given point during the day which storeid is not online (created). I do have a sister table where all of the storeid's are, so the join happens there. I can test created for IS NULL but it does not limit the query to today. select store.storeid, store.stName from store left outer join transaction on(store.storeid = transaction.storeid) where transaction.created IS NULL and store.active = 'yes' group by store.storeid; How can I limit this to today only without having to hard code a date into the query? TVMIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
