hunterwei/AccessUpdateWithJoin.sql

Created January 19, 2018 16:11

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hunterwei/3721626704d6fc6b28bf08798599a998.js"></script>
Save hunterwei/3721626704d6fc6b28bf08798599a998 to your computer and use it in GitHub Desktop.

Download ZIP

Update a table with joined table(s) in Microsoft Access database

Raw

AccessUpdateWithJoin.sql

	UPDATE ((TableA A
	INNER JOIN TableB B ON A.ID = B.AID)
	INNER JOIN TableC C ON B.ID = C.BID)
	SET A.DESC = C.DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment