SELECT MIN(CAST(a.BlankChequeNo AS int)) AS BlankChequeNo, b.SubentryName,
a.BlankChequeType, b.SubentryID
FROM BlankCheque a INNER JOIN
Subentrys b ON a.SubentryID = b.SubentryID
WHERE (a.Status = 0) AND (b.SStatus = 0) AND (b.TopDeptID = 3)
GROUP BY a.SubentryID, a.BlankChequeType, b.SubentryName, b.SubentryID
ORDER BY b.SubentryID
以前会有BlankChequeType的默认排序的,现在都是乱的
|