metacat/test/test-queries/doc2.sql @ 7266
| 1 |
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 |
/
|