Inner joins?

I’m trying to get this query to work

SELECT building_id, 
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

i’m sorry, but that makes no sense at all

your results show 3 rows, not 2

but those results could not possibly have come from that query, because those results have a dozen columns, whereas the query is written to return only 2 columns, building_id and name

If there are two projects with id=1 you will get two results