[Squirrel-sql-users] column aliases in MySQL
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: <ep...@we...> - 2010-09-24 20:07:03
|
Has anyone else noticed that when querying a MySQL db a field alias doesn't correctly show up in the query result header? For example: SELECT p.name AS productName, c.name AS customerName FROM product p JOIN customer c ON p.custID = c.custID WHERE (whatever) The result headers will show 'name' for both fields instead of the field alias set in the query. FYI. I also use SquirrelSQL with an Informix db and it does not exhibit this issue. Thanks, Eric P. |