select distinct(U.user_name) from usertable U,purchaseOrder p where u.user_type_id='UT107' and U.user_name like '%%' and p.supplier_id=U.user_id and P.Bom_id='BOM102'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)