[snip] Can I select the maximum value across multiple columns? ie, I'd like to select the highest value of buyCost AND sellCost in a table...where buy and sell are two different columns in the same table.
i actually have 4 comparisons to run, and don't want to have to execute 4 queries. [/snip] Sounds like an easy test, doesn't it? You will have to use the following syntax select max(foo), max(bar) from table keep in mind that foo and bar may not be in the same original tuple -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]