[Yurk@]

Код:

SELECT p.proizvod.name, t.tovar_name
FROM proizvod p, tovar t, raspred rs
WHERE t.tovar_id = 4
AND p.proizvod_id = 3
AND rs.proizvid_id = p.proizvod_id
AND rs.tovar_id = t.tovar_id