Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of magnus.eklund@gmail.com
 designates 209.85.217.214 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=from:content-type:content-transfer-encoding:subject:date:message-id
         :to:mime-version:x-mailer;
        b=UvaiQ5dvgLpE42wo3ztr1Fejw6JYS6690o2xYVUcGYzOq6A/Ejx5ciBE++DgmcKFZm
         KjoESr0cPerNphF5ZeuXxwC7kp7Y7cGvPI84gRog7b2WRpkAbnzxbMm/OTA6HlHLOrIy
         Jfo5wXxkD4Gy2eqIJpCjfiijm6XAAwrAMrlJs=
From: Magnus Eklund <magnus.eklund@gmail.com>
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Subject: Inner join / filtering
Date: Thu, 19 Nov 2009 18:00:21 +0100
Message-Id: <11C885EF-FB6E-4E09-95D8-2AC96F35F58C@gmail.com>
To: user@couchdb.apache.org
Mime-Version: 1.0 (Apple Message framework v1076)

Hi

I have two potentially very large collections of documents. Now I  
would like to be able to query one of them using for example  
startkey,endkey while at the same time filtering out documents not  
present in the other collection (based on the equality of some field  
common to both document types).

Is there any reasonable way to do this with CouchDb?

Thanks

- Magnus Eklund