I am testing to see if this product will do the reporting I need...
For example, I trying to use an IF/ELSE or DECODE function in the select list and then SUM() those rows. So, for example...
select brchs.brch,
jan_sum
from
(select distinct brch from "C:\TRANSACT.DBF" transdbf) brchs
left outer join (select brch, sum(IF(Ico="1AE",10, 25)) jan_sum from "C:\TRANSACT.DBF" where trans = "HON" and month ="B401" group by brch) jan on brchs.brch = jan.brch
Is this sort of select logic supported?