Re: ����������, ��� �������� ������

[Nikolay Trifonov]

>"Nikolay Trifonov" <[EMAIL PROTECTED]> wrote:
>>
>> group by s.name,r.name,r.id_region, select first 1 rp.price_retail from 
>> region_prices rp
>
>Скобки кто за тебя писать будет?

Дмитрий, выполняю

select
  s.name as storename,
  sum(pc.rest) as rest,
  sum(pc.reserve) as reserve,
  r.name as regionname,
  r.id_region,
  (select first 1 rp.price_retail from region_prices rp
   where (r.id_region=rp.id_region) and
   pc.id_product=rp.id_product) as PriceRetail
from stores s
left join regions r on s.id_region=r.id_region
join product_cards pc on s.id_store=pc.id_store and pc.id_product=582
group by 1,4,5, (select first 1 rp.price_retail from region_prices rp
   where (r.id_region=rp.id_region) and
   (pc.id_product=rp.id_product))
order by s.name

И получаю ошибку: 

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 13, char 17.
(.

Подскажите что не так?