check if record exists in join table

SELECT id,name FROM products WHERE EXISTS ( SELECT version_id FROM versionships WHERE products.id = versionships.version_id );