i'm amazed by the UNLOGICAL 'AS' command
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
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.