Re: Join issue

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Join issue
Дата
Msg-id 20060606182736.GI10018@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Join issue  ("Burak Seydioglu" <buraks78@gmail.com>)
Список pgsql-sql
On Tue, Jun 06, 2006 at 11:10:46AM -0700, Burak Seydioglu wrote:
> I have a query to return the latest contract and contract status for a
> house... What i am trying to do is to get the rate of electricity for the
> latest contract... I am trying to retrieve the latest provider rate before a
> contract is signed.

I don't have a proposal to rewrite, but I suspec this is going to be
easier with a query to get the latest provider rate in the FROM
clause.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard 
to use, but at least there is a lot of code underneath."    --Damien Katz


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

Предыдущее
От: "Burak Seydioglu"
Дата:
Сообщение: Join issue
Следующее
От:
Дата:
Сообщение: Re: How To Exclude True Values