SELECT SQLDICTIONARY.*, SYSTEMSEQUENCES.MAXVAL, SYSTEMSEQUENCES.NEXTVAL FROM SYSTEMSEQUENCES INNER JOIN SQLDICTIONARY ON SQLDICTIONARY.FIELDID = 0 AND SQLDICTIONARY.TABLEID = SYSTEMSEQUENCES.TABID AND SYSTEMSEQUENCES.NEXTVAL = (SYSTEMSEQUENCES.MAXVAL - 1)