OK - I had this done once and (of course) misplaced the solution. I have an A/P invoice table for example that contains invoices and payments. I want to display in a grid only those invoices that are outstanding using a view as the source. So far I've got
CREATE SQL VIEW apinquiry AS ;
select * from awards!apmaster where apmaster.invoicenum ;
in (select apmaster.vendornum, apmaster.invoicenum,
sum(apmaster.tranamount) as sumamount where sumamount <> 0
from awards!apmaster GROUP BY invoicenum ORDER BY
vendornum,invoicenum)
which gives me a 'function name missing ")"' error. What am I missing?
TIA
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein