[sqlalchemy] Exists/Correlate newbie question

2011-03-26 Thread dan
I've got a SQL query I am trying to convert over into sqlalchemy, however I just can't suss out the correlate and exists part of sqlalchemy. My query is: SELECT m_date,sensor_id,m_value,d_report_hour FROM multi_obs mo WHERE m_date = '2011-03-23T00:00:00' and m_date '2011-03-23T24:00:00'

Re: [sqlalchemy] Exists/Correlate newbie question

2011-03-26 Thread Michael Bayer
On Mar 24, 2011, at 2:19 PM, dan wrote: I've got a SQL query I am trying to convert over into sqlalchemy, however I just can't suss out the correlate and exists part of sqlalchemy. My query is: SELECT m_date,sensor_id,m_value,d_report_hour FROM multi_obs mo WHERE m_date =