A database error occurred while retrieving records. If this error persists, please contact us. Technical info: (SELECT  
		  salescatprod.stockid, stockmaster.longdescription, stockmaster.units
	    FROM salescatprod, stockmaster
	    WHERE 
         salescatprod.salescatid= 
         AND salescatprod.salessystemcode='ROYCRO' 
         AND salescatprod.stockid=stockmaster.stockid
         AND salescatprod.oemstockflag=0
)
  UNION (
     SELECT  
		  salescatprod.stockid as stockid, stockmasteroem.longdescription, 'ea'
	    FROM salescatprod, stockmasteroem
	    WHERE 
         salescatprod.salescatid= 
         AND salescatprod.salessystemcode='ROYCRO' 
         AND salescatprod.stockid = stockmasteroem.stockid
         AND salescatprod.oemstockflag=1
		 )
   ORDER BY stockid