Mysql 5 Ошибка в запросе unkown column g.kod_ms in on clause [MySQL]
Ulugbek © (2006-12-09 09:21:00)
Срочно помогите пожалуйста делаю запрос так
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:00) [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, а ты на него поля навесил
Наверх 
ЧАТ |
Орешник |
|
