Our first join

select g.type, p.first, p.last

from gadget g, person p

Where g.owner_id = p.id;