INSERT INTO `comp_purchase_order` (`companyID`, `createdBy`, `supplierID`, `formNo`, `serialNo`, `poDate`, `termAndConditionID`, `memo`, `purchaserID`, `exchangeRate`, `currencyID`) VALUES ('1', '16', '1', 'P020140725PHG', '(select serialNo from view_serial_comp_purchase_order where companyID = 1\r\n                   and formID = 40)', '2014-07-25', '5', 'dss', '6', '1.00000', '1')