Hi

iam trying to execute this statement. But Iam getting error

select m."Expense", sum(d."Amount") as "Amount"
from "expensesubtype" m left join "invoice" d on m.ID = d."ExpenseCategory"
where d."Status" != 'CAN' and extract(month from "d.InvDate") = 12
group by m."Expense"

is there something wrong with my ... extract(month from "d.InvDate") =
12? before this was added the query runs fine...

James