Strange query behavior

2004-02-13 Thread Linus Nikander
ifference between the two queries is that the second one has "active_odds AS AO" added to the FROM clause. Even though I don't use AO at all in the query the results still differ. Anyone have an explanation ? Having a superflous table in the WHERE clause shouldn't affect th

Autocolumn and pk

2004-02-10 Thread Linus Nikander
numbers (when i need them). That is going to clutter up my tables in the long run though, and isn't really something I want to do. Is that the only viable solution, or is there some functionality that I don't know of which does it better ? //Linus Nikander - [EMAIL PROTECTED] -- MySQL