Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/as_table.sql

Created June 11, 2021 17:29
Show Gist options
  • Save bartubozkurt/5dd853ae5d459e698d3d883c799d2d88 to your computer and use it in GitHub Desktop.
Save bartubozkurt/5dd853ae5d459e698d3d883c799d2d88 to your computer and use it in GitHub Desktop.
Download ZIP
With the AS expression, we can temporarily give short names to long and difficult to use table or field names
Raw
as_table.sql
SELECT co.name, ci.name
FROM city AS ci
JOIN country AS co
ON ci.country_id = co.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment