On 11:34 Thu 31 Aug , Renato Golin wrote: > Renald Buter wrote: > >Odd, eh? But what's worse, the JOIN between this column and other > >columns *also* uses this truncated values and the result is bogus. > > I wouldn't say odd, as you didn't specified any order I wouldn't rely on > the order of the output. Try ordering things for what you want and > you'll probably get the correct results.
I'm sorry, but I do not understand this answer: what order are you talking about? Could you perhaps give an example? The problem is that a simple 1-table query shows different answers depending on whether you select 1 or 2 columns. Thanks, Renald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]