mysql old 4.* query fails on 5.*

Thu, 31 May 2007 09:18:12 -0700 

Hi

I have upgraded to  5.0.22 and after a while I discovered that the
following query no longer works.. it fails claiming " Unknown column
'K.Klient_ID' in 'on clause' " which seems entirely wrong.

The query is as follows

select Td.Datum, Td.Text AS Action, Td.Enhet AS Tid, P.Fornamn AS Person
                                                From Klienter AS K, Tid As Td, 
Personal AS P
                                                JOIN Uppdrag AS U ON 
K.Klient_ID = U.Klient_ID
                                                WHERE Td.Uppdrag_ID = 101
                                                AND U.Uppdrag_ID = Td.Uppdrag_ID
                                                AND Td.Person = P.Personal_ID
                                                ORDER BY Td.Datum ASC

Anyone know whats wrong here?

Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to