Portable SQL/Common/Aliases
From Linuxnetworks
Contents
Alias for tables and columns
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