In this post, we will see how to resolve I’m trying to show null values as zeros, how would I join these tables together?
Question:
This is the query I have, as far as I can tell it should be correct except I am unsure how to combine the tables using the building as a common field.Best Answer:
If your query is throwing an error of s.building does not exist it is certainly because in your subquery the building column is aliased as ‘BUILD’ so you should join on l.building and s.”BUILD”.If you have better answer, please add a comment about this, thank you!
Source: Stackoverflow.com