Hello, i want to do a query with DATE object in mysql. I´ve got the folling table structure: <table name="download_list"> <column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" /> <column name="ListID" type="INTEGER" /> <column name="LastUpdate" type="DATE" /> <column name="DownloadLink" type="VARCHAR" size="120" /> <unique> <unique-column name="ListID"/> </unique> </table> <table name="partner"> <column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" /> <column name="listID" type="INTEGER" required="true" /> <column name="downloadActive" type="INTEGER" size="1" required="true" default="0" /> <unique> <unique-column name="listID"/> </unique> </table> <table name="partner_imports"> <column name="id" type="INTEGER" required="true" primaryKey="true" autoIncrement="true" /> <column name="partner_id" type="INTEGER" required="true" /> <column name="lastupdate" type="DATE" required="true" /> <column name="download_begin" type="DATE" /> <column name="download_end" type="DATE" /> <foreign-key foreignTable="partner"> <reference local="partner_id" foreign="id"/> </foreign-key> <unique> <unique-column name="partner_id"/> <unique-column name="lastupdate"/> </unique> </table> Now i want to make a query, which give´s me all data lines of table download_list, If column downloadActive of table partner is = 1 AND If the LastUpdate of the table download_list is newer than lastupdate of table partner_imports Can anyone help me with the solution !? Thanks Gerd