Re: [GENERAL] Distinct on a non-sort column

by user_id) ss where s.user_id = ss.user_id and s.date_submitted = ss.date_submitted; -- с уважением, Таир Сабыргалиев ТОО "BEE Software" Республика Казахстан, 01 г.Астана, ул.Сарайшык 34, ВП-27 Тел.: +7 (7172) 56-89-31 Сот.: +7 (702) 2173359 e-mail: tair.sabirgal...@bee.kz Tair Sabir

Re: [GENERAL] What is *wrong* with this query???

    ^ > > > > If I leave out the where clause entirely, that's an error also, > > ERROR:  syntax error at or near ";" at character …. > > LINE 5:  …  as bld ; > > ^  > > > > So, it&