Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 70881 invoked from network); 13 Mar 2009 13:43:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Mar 2009 13:43:34 -0000 Received: (qmail 13544 invoked by uid 500); 13 Mar 2009 13:43:31 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 13515 invoked by uid 500); 13 Mar 2009 13:43:31 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 13503 invoked by uid 99); 13 Mar 2009 13:43:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Mar 2009 06:43:31 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [83.97.50.139] (HELO jan.prima.de) (83.97.50.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Mar 2009 13:43:20 +0000 Received: from [192.168.1.100] (f053002156.adsl.alicedsl.de [::ffff:78.53.2.156]) (AUTH: LOGIN jan, TLS: TLSv1/SSLv3,128bits,AES128-SHA) by jan.prima.de with esmtp; Fri, 13 Mar 2009 13:42:59 +0000 Message-Id: <094453DE-AFFD-4905-A2F3-4A35304BC1FA@apache.org> From: Jan Lehnardt To: user@couchdb.apache.org In-Reply-To: <41139fcb0903130459td4f3d40ic4f418d7842c14ba@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Subject: Re: equivalent of JOINs in couchdb? Date: Fri, 13 Mar 2009 14:42:57 +0100 References: <41139fcb0903130459td4f3d40ic4f418d7842c14ba@mail.gmail.com> X-Mailer: Apple Mail (2.930.3) X-Virus-Checked: Checked by ClamAV on apache.org On 13 Mar 2009, at 12:59, Anand Chitipothu wrote: > Hi, > > I have been reading about couchdb and trying understand how it works. > One thing that i'm unable to understand is how to do equivalent of > JOINs in couchdb. > > Let me explain what I need with an example. > I want to store books in couchdb with each book having title, authors, > isbn, lccn, publisher and many other fields. > I would like to be able to query the system for any combination of > these. some thing like: > > type="book" and publisher="foo" and author="bar > type="book" and isbn="1234567890" > > How to do this in couchdb? http://www.cmlenz.net/archives/2007/10/couchdb-joins Cheers Jan --