Is there a way to have MySQL label columns returned from a select query with the complete column name, in table.column format? So if a column name is id, which is in the main table, can MySQL return main.id instead of just id. Sure I could alias each column, but if there is 30 columns, that's a lot of aliasing. Is there a way to alias a whole table, so each returned column is prefixed by a specified string? Thank you Hans [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php