How to substitute a value instead of a foreign key?

Question

SQL

There are tables stock and goods:

stock:
id (primary key)
goodID (foreign key -> goods.id) goods

:
id (primary key)
name

Answer 1

SQL JOIN - joining database tables
https://function-x.ru/sql_join.html