Path: utzoo!censor!geac!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!lll-winken!elroy.jpl.nasa.gov!sdd.hp.com!uakari.primate.wisc.edu!aplcen!boingo.med.jhu.edu!haven!uflorida!cs.fau.edu!rob
From: rob@cs.fau.edu (Robert Rittenhouse)
Newsgroups: comp.databases
Subject: SQL Query
Message-ID: <9J2Lw1w163w@cs.fau.edu>
Date: 30 Jan 91 23:24:55 GMT
Sender: bbs@cs.fau.edu (Waffle BBS)
Organization: Florida Atlantic University
Lines: 15

Is the following legal Ansi SQL:

Given:
Table Orders with attributes Productnumber, Price
Table Inventory with attributes Productnumber, Cost
the following query:
SELECT SUM(Price), SUM(Cost) 
  FROM Orders, Inventory
  WHERE Orders.Productnumber = Inventory.Productnumber

The Microrim people claim it's not (which is their excuse for it
returning incorrect answers in Rbase). I've looked in several texts
and found neither anything forbidding it nor any examples!

Rob R.