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