Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!ncrlnk!ncratl!tchriste
From: tchriste@ncratl.Atlanta.NCR.COM (Todd Christensen)
Newsgroups: comp.databases
Subject: UNIFY SQL question
Keywords: sql,unify
Message-ID: <552@ncratl.Atlanta.NCR.COM>
Date: 5 Sep 90 13:04:57 GMT
Organization: NCR Engineering & Manufacturing Atlanta -- Atlanta, GA
Lines: 24

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