Inner joins?

Databases
1

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?

image
image1538×233 22.3 KB

The assets table only shows 1 with that project_id

2

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

3

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