chilidogie
MIS
I know how to alias a field name in a select. Is there any way to alias a table ? (needed for my Access and SQL tables)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
table alias 1
- Thread starter chilidogie
- Start date
- Status
-
1
- #2
ousoonerjoe
Programmer
SELECT * FROM TableName tn WHERE ....
or
SELECT * FROM TableName AS tn WHERE ....
--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------
or
SELECT * FROM TableName AS tn WHERE ....
--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question