CODE EXAMPLE FOR SQL

joining tables

select s.identification, s.name, s.`shoe size`, p.price, p.year
from shoes s
join payment p on p.paymentid = s.identification