[comp.databases] UNIFY SQL question

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