Re: Inner Join of 3 tables

[Peter Brawley]

Just join part_number to description and to manufacturer ...

Select n.scpart, d.name, m.manufacturer, m.manupart
from partnumber n
join description d using(scpart)
join manufacturer m using(scpart);