." FROM ". TB_PREF."gl_trans as gl"
." LEFT JOIN ". TB_PREF."audit_trail as a ON
(gl.type=a.type AND gl.type_no=a.trans_no)"
." LEFT JOIN ". TB_PREF."comments as com ON
(gl.type=com.type AND gl.type_no=com.id)"
." LEFT JOIN ". TB_PREF."refs as refs ON
." FROM ". TB_PREF."gl_trans as gl"
." LEFT JOIN ". TB_PREF."audit_trail as a ON
(gl.type=a.type AND gl.type_no=a.trans_no)"
." LEFT JOIN ". TB_PREF."comments as com ON
(gl.type=com.type AND gl.type_no=com.id)"
." LEFT JOIN ". TB_PREF."refs as refs ON