Select Query

I want to write a select query for getting data into an internal table. This query is based on a condition. The data from the zcycle_details custom table has two fields event_date and cycle_act_date. The data should be selected such that the event_date field value containing date shoudld be greater than cycle_act_date.