query problem

Поиск
Список
Период
Сортировка
От ron_tabada
Тема query problem
Дата
Msg-id 20031108074404.14151.qmail@web14604.mail.yahoo.com
обсуждение исходный текст
Список 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.


Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger

В списке pgsql-sql по дате отправления:

Предыдущее
От: ronald@my.msuiit.edu.ph
Дата:
Сообщение: ...
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: search facilities