I'm trying to get a count of customer IDs (CID) tied to an invoice number.
There should never be more than one CID per invoice, but these can appear
multiple times in the table as customers pay on an invoice and payment
entries are made. For example, there are three payments by Client 105 on
Invoice 137295. So, I want to run a query to get that count, but the first
below is giving me a value of 3, and the 2nd lame attempt doesn't give me
anything but an error. How should the syntax read for this?
select count(CID) into vMyCIDCount from ARTRANS where INVOICE# = .vINVOICE#
(Gives me 3)
select count(select distinct CID from ARTRANS where INVOICE# = .vINVOICE#)
into vMyCIDCount (Blows chunks)
wwwww
( @ @ )
-------oOO---(_)---OOo-------
Damon J. Gray
Anvil Corporation Business Services
(360) 937-0770
oooo0 0oooo
( ) ( )
----------\ (----) /-----------
\__) (__/
