SourceCode/PROMS/SQL Data Tools/Search for all RNOs in a database.sql

select cc.* from contents cc
join items ii on ii.contentid=cc.contentid 
where ii.itemid in (select itemid from parts where fromtype=5)