--- In firebird-support@yahoogroups.com, David Johnson
<d_johnson@c...> wrote:

> select
> CAST("Date_Time" AS DATE) as call_date
> count (*) as call_count
> from CALLS a
> where call_count > 0
> full join
> select
> CAST("Date_Time" AS DATE) as call_date
> count (*) as call_count
> from CALLS b
> where resolved_count > 0
> on a.call_date = b.call_date
>
> I suspect that a full join is overkill, but it allows both for days

that

> you received no calls but resolved outstanding issues, and for days
> where you received calls but resolved none (both are bad situations

for

> a helpdesk, but that is all the more reason to support them in your
> management report).
>
>

i tried that (with commas on the call_date line) but i get the
following error when i try running the query

Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 6, char 1.
full.

any ideas?