Adam,
I just realised that issuing the SQL on one table produces the correct count.
SELECT sum(case when table2.date between '2007-07-13' and '2007-07-13' then 1 else 0
end) as sumx FROM table2 WHERE id = n;
This is working alright.
So the problem should lie in the last part:
from table2, table3
where table2.id = table3.id
and table2.id = n;
I think I need the UNION statement instead?
Håkan Jacobsson - System Developer
----------------------------------------------------------------
RELEVANT TRAFFIC EUROPE AB, Riddarg 17D, SE-114 57 Sthlm, Sweden
Mobile (+46) 736 56 97 58
Direct (+46) 8 56 24 98 05
Phone to office (+46) 8 678 97 50 || Fax (+46) 8 661 19 22
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
