From: ronald@my.msuiit.edu.ph
To: pgsql-sql@postgresql.org
Date: Sat, 8 Nov 2003 15:40:58 +0800
Message-ID: <1068277258.3fac9e0ada002@my.msuiit.edu.ph> (raw)
Hello everyone, Good day! Could anyone help me translate this query in Microsoft
Access to Postgresql. I'm having a difficulty. Pls...
Query1:
SELECT items.description, Sum(supplieditems.qty) AS SumOfqty
FROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemno
GROUP BY items.description;
Query2:
SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
FROM (items INNER JOIN OtherItem ON [items].[itemno]=[OtherItem].[Itemno]) INNER
JOIN customer ON [OtherItem].[Itemno]=[customer].[itemcode]
GROUP BY [items].[description];
Query3:
SELECT [Query1].[SumOfqty], [Query2].[SumOfqty],
[Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
FROM Query1, Query2;
I have translated Query1 and Query2 in POSTGRESQL but I don't know how to
implement Query3.
____________________________________________________________
Are you a student of MSU-IIT? Log on http://my.msuiit.edu.ph
and sign up for your My.MSUIIT E-mail Plus account now!
Are you an MSU-IIT alumnus? Log on http://www.alumni.msuiit.edu.ph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ronald@my.msuiit.edu.ph
Subject: Re:
In-Reply-To: <1068277258.3fac9e0ada002@my.msuiit.edu.ph>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox