SELECT a.ID,o.UID as 
OrderDocUID,o.OrderStyleID,a.StyleDocTreeID,a.BOMType,o.OrderDocType,
a.Code,a.IsCheckMaterial,a.IsCalculation,a.IsCheckPrice,a.IsPurchase,a.IsReceive, 
a.IsStockIn,a.IsFollowDoc,a.IsAssign,a.IsAssistantMaterial,a.IsMainMaterial,a.FilingUp,a.IsIntact, 
a.IsSubmit,a.SubmitDate,a.CheckState,a.CreateDate,a.CreateUserID,a.LastModifiedDate,a.ReferenceDate, 
tp.Name as TechnicPerson,ac.Name as CreateUserName,Cast(null as Image) as StyleImage, 
a.LastModifiedUserID,a.IsBreakDown,a.BreakDownDate,a.HasHanged,a.Remark,am.Name as LastModifiedUserName , 
o.DocCode as OrderCode,o.Code as StyleCode ,o.Name as StyleName,o.SessionType,cs.CustomName FROM 
OrderStyleBOM as a INNER JOIN view_OrderStyleExtend_ALL o ON a.StyleDocTreeID = o.StyleDocTreeID 
LEFT JOIN view_GoodsType vg on vg.ID = o.GoodsType 
LEFT JOIN AC_User tp ON o.TechnicPerson = tp.ID 
LEFT JOIN AC_User ac ON a.CreateUserID = ac.ID 
LEFT JOIN AC_User am ON a.LastModifiedUserID = am.ID 
LEFT JOIN Custom cs ON cs.ID = o.CustomID 
WHERE o.[DocCode] LIKE '%120392%' and a.BOMType = 0