1. Find data not available in Table B in Table A
Select DJBH from ZJ_SPLZYJB A Where Not Exists (Select Djbh from ZJ_SPLZB B Where A.djbh = B.DJBH)
2. Search DJBH in Table A, XH two fields are not unique records, that is, repeated records
Select DJBH || '-' || xh as djbhxh, count (djbh) from zj_fybxbd b Group by Djbh, XH