From: ronald(at)my(dot)msuiit(dot)edu(dot)ph
To: pgsql-sql(at)postgresql(dot)org
Subject:
Date: 2003-11-08 06:52:14
Message-ID: 1068274334.3fac929e1ea16@my.msuiit.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

  • Re: at 2003-11-10 17:17:00 from Louise Cofield

Browse pgsql-sql by date

  From Date Subject
Next Message ronald 2003-11-08 07:40:58
Previous Message ron_tabada 2003-11-08 06:02:15 help me...