Posted by bigsamurai on 09/29/09 11:33

Thanks. I have included the actual query I was running below.

SELECT ood.ood_watch_officer, ood.ood_start, ood.ood_end, ood.ood_date,
COUNT(ood.ood_date), ood_per.ood_per_no, ood_per.ood_per_name FROM ood,
ood_per
WHERE ood.ood_watch_officer=ood_per.ood_per_no
AND (ood.ood_date BETWEEN '$_POST[date1]' AND
'$_POST[date2]')
ORDER by ood_per.ood_per_name";

Two tables ood and ood_per

[Back to original message]