Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 87400 invoked from network); 12 Dec 2009 22:00:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Dec 2009 22:00:51 -0000 Received: (qmail 43292 invoked by uid 500); 12 Dec 2009 22:00:50 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 43203 invoked by uid 500); 12 Dec 2009 22:00:49 -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 43193 invoked by uid 99); 12 Dec 2009 22:00:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Dec 2009 22:00:49 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mirsal.ennaime@gmail.com designates 209.85.218.218 as permitted sender) Received: from [209.85.218.218] (HELO mail-bw0-f218.google.com) (209.85.218.218) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Dec 2009 22:00:47 +0000 Received: by bwz10 with SMTP id 10so1309007bwz.35 for ; Sat, 12 Dec 2009 14:00:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=Rl4+3Pzt58wwQjvwtTxWnU4R70drArVNPau7AGTjCD8=; b=DBhlwvToFwo6hSAwQj/bIbg9v167ys099Iww22KE5NXaN5/dKlGwkSz4dLqzQT0wKK +InpkADPtv8m3zL1RqUnf3jrENHDdi7W2zrVXTNb4kkO3uXyFta03Sq/VTvAnEiTsWV0 unVyTZPyvaVeMdjT9AyR8FgYjIDjnGtOAAEQs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=bReTKNRSmbAdnDioomI+r+LfHzAZUscm5Zqr8Szerg/7qheDtynNDWJ/4H0czLaZE+ aKiIDfpoHQwtv0iWKg7Skmt+948pUIqqTV+eXjYR2Yj8+7eA27zdsJQktQq0h91oT/9l mkTtbJWv7pADFF/bP4qBhAc6+kabtRAAvpddo= MIME-Version: 1.0 Received: by 10.204.48.141 with SMTP id r13mr1730043bkf.0.1260655226127; Sat, 12 Dec 2009 14:00:26 -0800 (PST) In-Reply-To: <4B2408BE.1030900@rogerbinns.com> References: <6adfa88d0912121238p3d31e20bn710d23357f80656e@mail.gmail.com> <4B240052.1050606@rogerbinns.com> <6adfa88d0912121251w69cffb21gd64aefa516067cb1@mail.gmail.com> <4B2408BE.1030900@rogerbinns.com> From: Mirsal Ennaime Date: Sat, 12 Dec 2009 22:58:43 +0100 Message-ID: Subject: Re: How to make equivalent of WHERE on JOINed table in CouchDB? To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 In your map function, emit [car.person_id, car.brand] then query your view using startkey / endkey It's usually called view collation. You can easily find more info all over the internet, this is a pretty common and simple case. PS: crossposting is rude indeed.