Re: TABLE Joins Problem

From: "Jan S via SQLMonster.com" <forum@xxxxxxxxxxxxxx>
Date: Thu, 11 Aug 2005 02:47:08 GMT

Sorry abt the crappy illustrations...Here it is again.
SALES(ISAL) PURCHASING(IPUR)
--------------------- -----------------------------
ItemGroup ItemGroup
ItemCode ItemCode
DocDate DocDate
Quantity Quantity
Total Total

What i need:
ItemGroup Total Sales Sold Qty Total Purchases Purchased
Qty
----------------- ---------------- ----------- ------------------
---- ---------------------
ACN 23432.90 234 1243.90
89
Etc.....

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-mseq/200508/1
.

Follow-Ups:
- Re: TABLE Joins Problem
  - From: Hugo Kornelis

References:
- TABLE Joins Problem
  - From: Jan S via SQLMonster.com

Prev by Date: TABLE Joins Problem
Next by Date: Query returning multiple rows
Previous by thread: TABLE Joins Problem
Next by thread: Re: TABLE Joins Problem
Index(es):
- Date
- Thread