|
Could someone tell me what is wrong with this query please?? select h.shortnotes, h.notificationdate,
max(hr.datereviewed) from hazard h left join hazardreview hr on h.hazardid = hr.hazardid where h.companyid = 9 and (extract(month from hr.datereviewed) =
7) group by h.notificationdate, h.shortnotes I get an error: _expression_ evaluation not supported |
_______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
