search

Datapolitan-Training / parks-advanced-analysis-sql

A one-day class reinforcing the skills necessary to leverage a relational database to clean, process, and visualize NYC Parks data
http://training.datapolitan.com/parks-advanced-analysis-sql
Creative Commons Attribution Share Alike 4.0 International
0 stars 0 forks source link

Fix join to pull from the tbl_PIPAllSites #44

Closed datapolitan closed 5 years ago

datapolitan commented 5 years ago

tbl_PIP_AllSites is more canonical and the column names are not SQL standard and need to be referenced as below.

SELECT pip.*, sites.[Prop Name],sites.[Site Name]
FROM tbl_PIP_InspectionMain AS pip
LEFT JOIN tbl_PIP_AllSites AS sites ON pip.[Prop ID] = sites.[Prop ID]