Difference between revisions of "Portable SQL/Common/Aliases"
From Linuxnetworks
(relocated quotes/numeric section) |
(→Alias for tables and columns) |
||
| Line 2: | Line 2: | ||
| − | = | + | = Aliasing tables = |
Don't use the keyword "AS" between name and alias as no DBMS requires it and some don't recognize it. Instead, always write | Don't use the keyword "AS" between name and alias as no DBMS requires it and some don't recognize it. Instead, always write | ||
Revision as of 16:01, 10 March 2007
Contents
Aliasing tables
Don't use the keyword "AS" between name and alias as no DBMS requires it and some don't recognize it. Instead, always write
SELECT * FROM table t WHERE t.id = 0
Back to Overview
