Table Vendor consists of a Vendor ID (vendorid) and the Vendor (vendor). Table Type consists of the Type ID (typeid) and the Type (type).

The equipment table consists of id, vendorid, typeid, partnum, details, cost, markup

What I need is to query all records in Equipment and have the vendorid field filled in from the matching "vendor" record in the vendor table and have the typeid filled in from the matching "type" record in the type table.

SELECT vendor.vendor as vendor, type.type as type, id, partnum, details, cost, markup from vendor, type, equipment where vendor.vendorid = equipment.vendorid and type.typeid = equipment.typeid.

I know that SQL is incorrect but I hope you can understand what I want from reading it.

p.s. this is against MySQL