SELECT job_mast.JOBCARD_NO,IIF(ISNULL(ITEMMAST.ITEM),'',itemmast.item) AS item, ;
	IIF(ISNULL(ISSUEBOD.QTY),0,issuebod.qty) as qty;
	FROM JOB_MAST LEFT OUTER JOIN ISSUE ON JOB_MAST.JOBCARD_NO = ISSUE.JOBCARD_NO ;
		LEFT OUTER JOIN ISSUEBOD ON ISSUE.ISSUE_NO = ISSUEBOD.ISSUE_NO ;
		LEFT OUTER JOIN ITEMMAST ON ISSUEBOD.ITEM_NO = ITEMMAST.ITEM_NO ;
	WHERE JOB_MAST.JOBCARD_NO = lcjobcard_no 
	
