Thanks Lee. If we want to find matching records from all the XMLs in database: DB1 with all the XMLs in database: DB2, then we need to access DB2 from DB1 and then perform the join right?
Also the doc_key element, has an attribute field doc_key_context and we want to find matching records based on <doc_key doc_key_context="a" 20021234> On Wed, Mar 31, 2010 at 10:17 AM, Lee, David <[email protected]> wrote: > for $a = doc(“DB1.xml”)//doc_key > > for $b = doc(“DB2.xml”)//doc_key > > where $a/doc_key_context eq $b/doc_key_context > > return …. > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Gaya Rac > *Sent:* Tuesday, March 30, 2010 12:07 PM > *To:* [email protected] > *Subject:* [MarkLogic Dev General] Inner join > > > > Hi, > > Is there a way to perform joins on Mark logic databases? > > I've a database:DB1 which has key field > <doc_key doc_key_context="a" 20021234> > <doc_key doc_key_context="b" 1234> > > I've a second database:DB2 which has same key field > <doc_key doc_key_context="a" 20021234> > <doc_key doc_key_context="b" 1234> > > How can I return all the matching documents from DB1, DB2. > > Thanks, Gayathri > > _______________________________________________ > General mailing list > [email protected] > http://xqzone.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
