On Thursday 31 August 2006 12:21, Renald Buter wrote: > The problem is that a simple 1-table query shows different answers > depending on whether you select 1 or 2 columns.
Relational databases are founded on mathematical set theory. Unless you specify an ORDER BY stanza in your query, the database is free to pick any sorting order it wants to, as sets have no order. -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]