From: Louise Cofield <lcofield@box-works.com>
To: ronald@my.msuiit.edu.ph
To: pgsql-sql@postgresql.org
Subject: Re:
Date: Mon, 10 Nov 2003 10:17:00 -0700
Message-ID: <00e401c3a7ae$74146e70$7801a8c0@Louise> (raw)
In-Reply-To: <1068274334.3fac929e1ea16@my.msuiit.edu.ph>
You will have to use a WHERE clause or a JOIN in query three, so you
will have to include some field, such as itemno, in the result sets of
both query1 and query2 on which you can join with where or join. Such
as:
Select query1.sumofqty as sum1, query2.sumofqty as sum2, query1.sumofqty
- query2.sumofqty as remain from query1, query2 where query1.<itemno> =
query2.<itemno>
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of
ronald@my.msuiit.edu.ph
Sent: Friday, November 07, 2003 11:52 PM
To: pgsql-sql@postgresql.org
Subject: [SQL]
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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: lcofield@box-works.com, ronald@my.msuiit.edu.ph
Subject: Re:
In-Reply-To: <00e401c3a7ae$74146e70$7801a8c0@Louise>
* 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