I’m trying to get this query to work
SELECT building_id,buildings.name
FROM buildings
INNER JOIN sites ON buildings.site_id = sites.site_id
INNER JOIN projects ON sites.site_id = projects.site_id
INNER JOIN assets ON projects.project_id = assets.project_id
WHERE assets.project_id = 1
I get 2 results, but shouldnt I only get 1?
The assets table only shows 1 with that project_id