Portable SQL/Common/Aliases

From Linuxnetworks
< Portable SQL
Revision as of 16:01, 10 March 2007 by Nose (Talk | contribs)

Jump to: navigation, search


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