Hi All,
I am trying to get some result on the following query:
SELECT DISTINCT A.RECNAME, D.rowcnt
FROM PSRECDEFN A, PSRECFIELD B, PSTREENODEPVW C, sysindexes D
WHERE C.TREE_NODE = A.RECNAME
AND A.RECNAME = B.RECNAME
AND (B.FIELDNAME like '%SSN%')
AND A.QRYSECRECNAME = ' '
AND 'PS_' + A.RECNAME = D.name
Now the question is in regards to sysindexes. What is the criteria for
this table (will all records with data be in this table)? One of my
RECNAME is not in sysindexes and why is it not? It has data and is
used for many purposes but it does not show up in sysindexes???
Thanks,
-ok