Hi there. Just recently I have started to investigate a possible future use of mySql at my company. As part of this investigation I have come across one seemingly trivial obstacle, but an obstacle very important for me. What I wonder is if there is no means of renaming a column in a sql select phrase in mySql? In, par example, Oracle this i simply done with "SELECT group_id g, time t FROM tbl_Groups"n if the desired outcome is that the group_id column is presented as "g". Thankful for any possible answer.
_______________________ Mikaela Holmberg M Sc Systems Developer OSIX AB Lumavägen 6, SE-120 31 Stockholm Direkt: +46 8 50 600 667 Mobil: +46 70 597 06 67 --------------------------------------------------------------------- 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