isnull(WO.Production_Order_Id,-1) IsWOCreated
//
SELECT PO.Id,DueDate,isnull(WO.Production_Order_Id,-1) IsWOCreated
FROM ProductionOrder PO left outer join dbo.WorkOrder WO
on PO.Id =WO.Production_Order_Id
Thursday, October 18, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment