>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 >order by s.name
É × 1.5.3 ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ × IBExpert ÐÏÌÕÞÁÀ ÏÛÉÂËÕ Invalid token. Dynamic SQL Error. SQL error code = -104. Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause). >÷ Ô×ÏÅÍ ÚÁÐÒÏÓÅ ÍÅÎÑ ÓÍÕÔÉÌ ×ÏÔ ÜÔÏÔ ËÕÓÏÞÅË: >from stores s left join regions r on s.id_region=r.id_region, >product_cards pc >where s.id_store=pc.id_store >and pc.id_product=582 > >úÄÅÓØ ÔÙ ÓÍÅÛÉ×ÁÅÛØ Ñ×ÎÙÊ join Ó ÎÅÑ×ÎÙÍ imho. × stores É × product_cards ÐÒÉÓÕÔÓÔ×ÕÀÔ ×ÓÅ ÚÁÐÉÓÉ, Á × regions ÔÏÌØËÏ ÞÁÓÔØ. ðÏÜÔÏÍÕ É ÎÕÖÅÎ ÄÌÑ ÎÅÇÏ left join á ÞÔÏ × ÄÁÎÎÏÍ ÓÌÕÞÁÅ ÐÌÏÈÏÇÏ? óËÏÒÏÓÔØ ÍÅÎÑ ÕÓÔÒÁÉ×ÁÅÔ. --~--~---------~--~----~------------~-------~--~----~ -~----------~----~----~----~------~----~------~--~---
