| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Join issue |
| Date: | 2006-06-06 18:27:36 |
| Message-ID: | 20060606182736.GI10018@phlogiston.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)crankycanuck(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2006-06-06 18:56:39 | Re: How To Exclude True Values |
| Previous Message | Burak Seydioglu | 2006-06-06 18:10:46 | Join issue |