From: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de> |
---|---|
To: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query question |
Date: | 2002-11-28 14:29:03 |
Message-ID: | 03ae01c296ea$7ff82e00$81c206d4@office.turtleentertainment.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The first was fine, thanks, its working now..
Regards,
Bjoern
----- Original Message -----
From: "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: "Björn Metzdorf" <bm(at)turtle-entertainment(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, November 28, 2002 3:21 PM
Subject: Re: [GENERAL] Query question
Oops, should have read properly. Do it as:
SELECT m.*
FROM table1 m,
table4 l,
table2 ms
LEFT JOIN
table3 s ON ...
So doing m.* works to select the columns returned does it? I'm sure last
time I
tried it it didn't.
I wrote:
Just move table3 s to be last table specified before the left join phrase.
--
Nigel J. Andrews
On Thu, 28 Nov 2002, Björn Metzdorf wrote:
> Hi,
>
> This version should theoretically do what I want, but it does not work (it
> gives "ERROR: Relation "s" does not exist"):
>
> ------ snip -------
> SELECT m.*
> FROM table1 m,
> table2 ms,
> table3 s,
> table4 l
> LEFT JOIN table5 c ON s.id = ms.slot
> WHERE m.id = 262451
> AND ms.value2 = m.id
> AND l.id = m.value
> AND c.id = s.contestant
> ORDER BY m.date ASC
> ------ snap -------
>
>
> Thanks for your help.
>
> Regards,
> Bjoern
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-11-28 14:31:11 | Re: Query question |
Previous Message | snpe | 2002-11-28 14:22:34 | tuplestore : write failed |