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