| 12345 |
- select q.RecID as id,l.Line+' '+l.Describe as Line,q.ItemNum,convert(varchar(10),r.Op)+' '+IsNull(r.Descr,'') as Op,i.Descr as imgType,q.Path,q.Descr,q.Rev,q.SortID from QualitySegmentImage q
- left join ImageType i on q.ImageTypeID=i.ImageTypeID and q.[Domain]=i.[Domain]
- LEFT JOIN LineMaster l on q.Line=l.Line AND q.[Domain]=l.[Domain]
- LEFT JOIN RoutingOpDetail r on q.Op=r.Op AND q.[Domain]=r.[Domain] and r.RoutingCode=q.ItemNum
- WHERE q.[Domain]='{<UserFactoryNum>}'
|
