i was hoping to have a query something like this:
select rateid from rate r
left outer join machinerate mr on mr.rateid = r.rateid
where mr.machineid = :machineid
and r.ratemonth = month(?startdate)
and r.rateyear = year(?stardate)
but interbase doesnt seem to have the month() and year() functions like mssql (ick.. sorry i had to say that)
are there equivalent functions??