Some short instructions on how to accomplish a join on three or more SQL database tables but also using multiple keys/columns as well. Good StackOverflow reference: https://stackoverflow.com/questions/24639504/mysql-join-3-tables-using-multiple-columns-keys Three different tables used: 1. UserDivisions An old legacy table containing Division and it’s ID: 2. MediaCategoryDivisionMap This table maps the Division ID of the first table to …

Continue reading ‘How to join multiple tables with multiple keys / columns in SQL’ »