<![CDATA[FrontAccounting forum — systypes.inc error?]]>2014-09-05T22:41:38ZPunBBhttps://frontaccounting.com/punbb/viewtopic.php?id=5142<![CDATA[Re: systypes.inc error?]]>I can agree that it looks better with AS, but it is not needed in mysql.
/Joe
]]>https://frontaccounting.com/punbb/profile.php?id=32014-09-05T22:41:38Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=20688#p20688<![CDATA[systypes.inc error?]]>Is there something wrong in Line 34 of includes/systypes.inc ?
$sql = "SELECT max(last_no) last_no FROM ($sql1 UNION $sql2) a";
Should it not be (inserted AS):
$sql = "SELECT max(last_no) AS last_no FROM ($sql1 UNION $sql2) a";