Re: help me... - Mailing list pgsql-sql

From Yasir Malik
Subject Re: help me...
Date
Msg-id Pine.SGI.4.58.0311091558180.75486@guinness.cs.stevens-tech.edu
Whole thread Raw
In response to help me...  (ron_tabada <ron_tabada@yahoo.com>)
List pgsql-sql
Hi,
I'm usually wrong, but you can create a view for Query1 and Query2.  That
is do
create view Query1 [your query for query1];
create view Query2 [your query for query2];

Then what you are doing should work.  Are views offered in Access?
Regards,
Yasir

On Sat, 8 Nov 2003, [iso-8859-1] ron_tabada wrote:

> Date: Sat, 8 Nov 2003 06:02:15 +0000 (GMT)
> From: "[iso-8859-1] ron_tabada" <ron_tabada@yahoo.com>
> Reply-To: ronald@my.msuiit.edu.ph
> To: pgsql-sql@postgresql.org
> Subject: [SQL] help me...
>
> 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.
>
>
> ---------------------------------
> Want to chat instantly with your online friends?Get the FREE
Yahoo!Messenger



pgsql-sql by date:

Previous
From: Christopher Browne
Date:
Subject: Re: transaction management in plpgsql functions
Next
From: Chester Kustarz
Date:
Subject: Re: transaction management in plpgsql functions