SELECT MAX(entryno) AS m FROM tbl1 UNION SELECT MAX(exitno) AS m FROM tbl2
SELECT CASE WHEN MAX(indledger.entryno) > MAX(cash_indledger.entryno) THEN MAX(indledger.entryno) ELSE MAX(cash_indledger.entryno) END FROM indledger, cash_indledger;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)