How to select only those records that are written in another table?

Question

MySQL

Hello, here are my tables:
1) projects - A table that stores projects
id
title
src_id
created_at
2) images - and here all project images are stored.
id
project_id
src
size
How to select from the table -- only those records from `images` that were recorded in the `projects` table (src_id serves as an identifier for selection) ?

Answer 1

src_id serves as an identifier for the fetch

maybe you meant project_id?

SELECT images.*
FROM images INNER JOIN projects
ON images.project_id = projects.id
WHERE projects.id IS NOT NULL

this query will return all fields from the images table
whose project_id refers to an existing entry in projects