Re: left joins
От
Ragnar Hafstað
Тема
Re: left joins
Дата
Msg-id
1120695557.14290.22.camel@localhost.localdomain
Ответ на
Re: left joins (Nick Stone)
Список
Дерево обсуждения
left joins "Grant Morgan" <grant@ryuuguu.com>
Re: left joins "Nick Stone" <nick@harelane.com>
Re: left joins Ragnar Hafstað <gnari@simnet.is>
Re: left joins Tony Wasson <ajwasson@gmail.com>
Re: left joins "Grant Morgan" <grant@ryuuguu.com>
Re: left joins Tom Lane <tgl@sss.pgh.pa.us>
Re: left joins Richard Huxton <dev@archonet.com>
On Wed, 2005-07-06 at 11:33 +0100, Nick Stone wrote: > I've had exactly yhe same problem - try changing the query to. > > select count(*) > from h left join p using (r,pos) and p.r_order=1 > where h.tn > 20 > and h.tn < 30 really ? is this legal SQL ? is this a 8.0 feature ? I get syntax error at or near "and" at character 41 gnari
В списке pgsql-sql по дате отправления
