select... 
from Widget-Attribute as wa, Production as p
where .... 
and wa.revision = p.revision;