Main
Products
Offshore Outsourcing
Customers
Partners
ContactUs
JDBC Databases
HXTT Access v7.1
HXTT Cobol v5.0
HXTT DBF v7.1
Buy Now
Support
Download
Document
FAQ
HXTT Excel v6.1
HXTT Json v1.0
HXTT Paradox v7.1
HXTT PDF v2.0
HXTT Text(CSV) v7.1
HXTT Word v1.1
HXTT XML v4.0
Offshore Outsourcing
Free Resources
Firewall Tunneling
Search Indexing Robot
Conditional Compilation
Password Recovery for MS Access
Password Recovery for Corel Paradox
Checksum Tool for MD5
Character Set Converter
Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City
(
abbr,
HXTT
)
HXTT DBF
Reading an aliased an one non-aliased column
Robbert Jan Grootjans
2010-12-09 11:26:17
When doing the following query:
select t1.field, t2.field as targetfield
from table1 t1
left join table2 t2 on t1.id = t2.id
I would expect the columns 'field' and 'targetfield'. In stead the first columnname is 't1.field'. The second is as I expect.
Re:Reading an aliased an one non-aliased column
HXTT Support
2010-12-10 06:55:16
Supported. Please download the latest package.
Search Key
Search by
Email
Subject
Message
Last 50 Questions
Enter your search terms
Submit search form
Web
www.hxtt.com
Email:
webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. |
Privacy
|
Legal
|
Refund
|
Sitemap