MySQL Forums
Forum List  »  General

i'm amazed by the UNLOGICAL 'AS' command
Posted by: olivier Hericord
Date: October 10, 2004 10:44AM

hi,

i'm using MySQL for years and i'm amazed i always have to populate my queries with such things:

select tbl1.name as tb1_name, tbl2.name as tb2_name from tbl1,tbl2 where .......

In my mind , most of the time my table is my object and my field is my Method like in OOP!!!!!

it's amazing that i can't write select * from tbl1, tbl2 where ..... and being abble to browse the result and being able to fetch tbl1.name and tbl2.name !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

in the terminal such a querie gives 2 colums entitled 'name'......WHAT THE HELL!!!!!!!!! why these colums are not entitled 'tbl1.name' and 'tbl2.name'???????????????

i can't understand such a limitation

Options: ReplyQuote


Subject
Written By
Posted
i'm amazed by the UNLOGICAL 'AS' command
October 10, 2004 10:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.