Mysql 5 Ошибка в запросе unkown column g.kod

← →
Ulugbek (2006-12-09 09:21) [0]

Срочно помогите пожалуйста делаю запрос так
select g.kod_ms, sp.name,"удель.вых.м/г3" as type, me.name,g.mes,"факт" as fak, sum(k.p2+k.p4+k.p6+k.p8+k.p10+k.p12+k.p14+k.p16+k.p18+k.p20+k.p22+k.p24)/sum(g.p2+g.p4+g.p6+g.p8+g.p10+g.p12+g.p14+g.p16+g.p18+g.p20+g.p22+g.p24) as dayly from v_gaz g, kond k join spr_ms sp on g.kod_ms=sp.kod join mesac me on k.mes=me.kod where g.god =2008 and g.mes between 1 and 2 and g.kod_ms=k.kod_ms and g.mes=k.mes and k.god=g.god group by g.kod_ms, g.mes union select g.kod_ms, sp.name,"Газ" as type, me.name,g.mes,"факт" as fak, sum(g.p2+g.p4+g.p6+g.p8+g.p10+g.p12+g.p14+g.p16+g.p18+g.p20+g.p22+g.p24) as dayly from gaz g join spr_ms as sp on g.kod_ms=sp.kod join mesac as me on k.mes=me.kod where god =2008 and mes between 1 and 2 group by g.kod_ms, g.mes union select k.kod_ms, sp.name,"Конденсат" as type,me.name, k.mes,"факт" as fak ,sum(k.p2+k.p4+k.p6+k.p8+k.p10+k.p12+k.p14+k.p16+k.p18+k.p20+k.p22+k.p24) as dayly from kond k join spr_ms as sp on g.kod_ms=sp.kod join mesac as me on k.mes=me.kod where god = 2008 and mes between 1 and 2 group by k.kod_ms,k.mes ORDER BY kod_ms, type, mes
Выдает ошибка unkown column g.kod_ms in on clause в чем проблема

← →
Desdechado © (2006-12-09 21:16) [1]

from kond k join spr_ms as sp on g.kod_ms=sp.kod join mesac as me on k.mes=me.kod
в третьем запросе нет алиаса G, а ты на него поля навесил

Mysql 5 Ошибка в запросе unkown column g.kod_ms in on clause Найти похожие ветки