tchriste@ncratl.Atlanta.NCR.COM (Todd Christensen) (09/05/90)
In trying to generate tabular output from our general ledger system, I have run into the following problem/question: What would be the (easiest, most efficient, only) way to generate this output: Accountname Total A Total B Total A * C Where File1 = accountname, accountnumber File2 = accountnumber, balance File1 is one-to-many with File2 Total A is sum(balance) where condition_set_1 is true Total B is sum(balance) where condition_set_1 is false Total A * C is Total A multiplied by a local variable I can only generate this information line-by-line currently, and have run out of other ideas. Knowing UNIFY SQL doesn't allow Views, what can be done? Todd Christensen, Financial Services NCR E&M Atlanta