Subversion Repositories DevTools

select *  from boms bm, production_bom prodbom, bom_names bn, dm_projects dmp

where bm.bom_id = prodbom.bom_id

and bn.bom_name_id = bm.bom_name_id

and dmp.proj_id = prodbom.proj_id

order by dmp.proj_name