bartubozkurt/as_table.sql

Created June 11, 2021 17:29

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bartubozkurt/5dd853ae5d459e698d3d883c799d2d88.js"></script>
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