Hi DMX Crew,
Before I began to use the DMX Extensions I wrote my queries by hand or using DB Studio Forge.

I have the following query which I am trying to replicate using DMX Zone Extensions and keep failing and its quite frustrating. I was hoping you could help explain how I would go about this?

Here is the query:

SELECT rates.Property_Reference,   rates.season,   SUM(rates.rate) AS expr1
FROM calendar   INNER JOIN rates     ON calendar.date_ >= rates.start_date AND calendar.date_ <= rates.end_date
WHERE calendar.date_ BETWEEN 'Start' AND 'End'

Any help with this problem would be more then appreciated. I would really like to have all my pages and queries singing from the same hymn sheet

Many thanks and Happy Easter!
Dave.