[sqr-users] Fwd: Select question

["Brooke Funk" <Brooke.Funk@firstfedbankkc.com>]

How does one format the line when within your select statement one of the 
fields you are trying to pull is out of a select statement?  I keep getting 
unbalanced parentheses error.  If I use TOAD and run it, it works fine, but  
I'm not sure how to work it here.

begin-select distinct
a.acctnbr &acct
count(*) &count 
((select count(acctnbr) 
        from rtxn
         where acctnbr = a.acctnbr
         and origpostdate >= to_date('01/01/2004','MM/DD/YYYY')
        and rtxntypcd = 'CWTH')) &ChecksWritten
((select count(acctnbr) 
        from rtxn
         where acctnbr = a.acctnbr
         and origpostdate >= to_date('01/01/2004','MM/DD/YYYY')
                and rtxntypcd = 'CWTH'
group by a.acctnbr having count(acctnbr) > 0)  /count(*)) * 100 
&AvgChecksWritten       



NOTICE:  This e-mail is intended solely for the use of the
individual to whom it is addressed and may contain information
that is privileged, confidential or otherwise exempt from
disclosure.  If the reader of this e-mail is not the intended
recipient or the employee or agent responsible for delivering
the message to the intended recipient, you are hereby notified
that any dissemination, distribution, or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please immediately notify us by replying
to the original message at the listed e-mail address.

Thank you.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users