/* Check for recursive joins. */
SELECT J1.FROMTABLE FROMTABLE1, J1.FROMFIELD FROMFIELD1, 
J1.TOTABLE TOTABLE1, J1.TOFIELD TOFIELD1
FROM SYSDBA.JOINDATA J1, SYSDBA.JOINDATA J2
WHERE  J1.FROMTABLE = J2.TOTABLE 
AND J1.TOTABLE = J2.FROMTABLE 
AND J1.FROMFIELD = J2.TOFIELD 
AND J1.TOFIELD = J2.FROMFIELD

/* Bad to join */
SELECT J.FROMTABLE AS 'FROM TABLE NAME', J.TOTABLE AS 'TO TABLENAME', 
JOINID, J.FROMTABLE +' IS THE INCORRECT ENTRY' AS 'MESSAGE' FROM
SYSDBA.JOINDATA J LEFT OUTER JOIN SYSOBJECTS SO1 ON J.FROMTABLE=SO1.NAME
WHERE (J.FROMTABLE NOT IN(SELECT NAME FROM SYSOBJECTS))
AND J.FROMTABLE<>'*'

/* bad from join */
SELECT J.TOTABLE AS 'TO TABLE NAME',J.FROMTABLE AS 'FROM TABLENAME', 
JOINID, J.TOTABLE+' IS THE INCORRECT ENTRY' AS 'MESSAGE' FROM
SYSDBA.JOINDATA J
LEFT OUTER JOIN SYSOBJECTS SO2 ON J.TOTABLE=SO2.NAME
WHERE (J.TOTABLE NOT IN(SELECT NAME FROM SYSOBJECTS))
AND J.FROMTABLE<>'*'