hello,
I want to select a column twice but get the results using two different conditions. SELECT tbl.colA, tbl.colA from tbl where tbl.info = B (the first colA) and tbl.info = C (for the second colA) I hope this makes sense. Thanks __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]