Project

General

Profile

1 2230 jones
SELECT DISTINCT xd.docid,xd.docname,xd.doctype,xd.date_created, xd.date_updated, xd.rev
2
  FROM xml_documents xd, xml_nodes xn
3
 WHERE xn.rootnodeid = xd.rootnodeid
4
   AND xn.nodedata LIKE '%'
5
/