Hello, Nikolay!
You wrote on Thu, 25 May 2006 00:35:35 +0300:
NT> Dynamic SQL Error.
NT> SQL error code = -104.
NT> Invalid expression in the select list (not contained
NT> in either an aggregate function or the GROUP BY clause).
Понятно. IMHO подзапрос не коррелирован с внешним запросом, поэт
Hello, Nikolay!
You wrote on Tue, 23 May 2006 19:08:45 +0300:
Вот мой запрос, выполняется на ура в 1.5.2 (в двойке тоже работает):
start clipboard
/* оборотная ведомость ТМЦ */
select k1.store,
min(s2.name) as st_name,
min(s2.fpr) as centr,
k1.a
Hello, Nikolay!
You wrote on Mon, 22 May 2006 02:35:42 +0300:
NT> select s.name as storename, sum(pc.rest) as rest, sum(pc.reserve) as
NT> reserve,
NT>r.name as regionname, r.id_region,
NT>(select first 1 rp.price_retail from region_prices rp
NT>where (r.id_region=rp.id_
3 matches
Mail list logo