Hello guys..
I'm trying to use MySQL 5.0.15 , but my applications not work
The Select :
select PEDCERT.id as idped,count(*),'CE' as cer
from asddb.PEDCERT, asddb.MOVIMENTO m
where m.dat >= '2005/01/01' and m.dat <= '2005/12/31' and PEDCERT.idmov
= m.ID
group by m.dat;
WORKS PERFECT !!!!
but , if i add a left join like :
select pdomeupau.id, count(*), sum(v0.valor),
'CERTIDÕES' as cert
from asddb.PEDCERT, asddb.MOVIMENTO m
left join asddb.ORCAMENTO v0 on (v0.idato = asddb.PEDCERT.id) and
(v0.tipato = 'CC') and v0.codcta = '02'
where m.dat >= '2005/01/01' and m.dat <= '2005/12/31' and
pdomeupau.idmov = m.ID
group by m.dat
tehe Server says
Unknowmn column "PEDCERT.id' in 'on clause'
This is a bug ?
MySQl 5.0.15 on Linux box using innodb tables.
--
-------------------------------------------------------------------------
++ Dyego Souza Dantas Leal ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 2106-1212
look: cannot open my eyes Fax : +55 041 296 -6640 -------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]