At 15:57 -0200 11/7/05, Dyego Souza Dantas Leal wrote:
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.
This is due to changes made to join processing in 5.0.12 for compliance
with SQL:2003. You can find information about these changes here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
In your case, you might try changing this:
asddb.PEDCERT, asddb.MOVIMENTO m
To:
(asddb.PEDCERT, asddb.MOVIMENTO m)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
