Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7DDA8F1D8 for ; Wed, 27 Mar 2013 19:33:13 +0000 (UTC) Received: (qmail 25856 invoked by uid 500); 27 Mar 2013 19:33:12 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 25829 invoked by uid 500); 27 Mar 2013 19:33:12 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 25821 invoked by uid 99); 27 Mar 2013 19:33:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Mar 2013 19:33:12 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [176.9.111.84] (HELO ssl.backendmedia.com) (176.9.111.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Mar 2013 19:33:08 +0000 Received: from localhost (unknown [127.0.0.1]) by ssl.backendmedia.com (Postfix) with ESMTP id 2ABE35EFE37E for ; Wed, 27 Mar 2013 19:32:49 +0000 (UTC) X-Virus-Scanned: amavisd-new at backendmedia.com Received: from ssl.backendmedia.com ([127.0.0.1]) by localhost (hq2.backendmedia.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lOlo6k4ZcHkp for ; Wed, 27 Mar 2013 20:32:48 +0100 (CET) Received: from [192.168.0.177] (77-58-147-243.dclient.hispeed.ch [77.58.147.243]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: smith@pooteeweet.org) by ssl.backendmedia.com (Postfix) with ESMTPSA id 9C8595EFE37B for ; Wed, 27 Mar 2013 20:32:48 +0100 (CET) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 6.3 \(1503\)) Subject: Re: sorting with join... probably JCR-3498 :(( From: Lukas Kahwe Smith In-Reply-To: <1364412428312-4658081.post@n4.nabble.com> Date: Wed, 27 Mar 2013 20:32:45 +0100 Content-Transfer-Encoding: quoted-printable Message-Id: References: <1364371497692-4658064.post@n4.nabble.com> <878CDDCD-EB3B-47CA-9C5D-92F246F00D6B@pooteeweet.org> <1364412428312-4658081.post@n4.nabble.com> To: users@jackrabbit.apache.org X-Mailer: Apple Mail (2.1503) X-Virus-Checked: Checked by ClamAV on apache.org On Mar 27, 2013, at 20:27 , rosselet wrote: > Hi.. thanks for the feedback. I thought that SQL1 does not support = joins.. I > guess I'll have another look. Or are you suggesting a different = approach? SQL1 does indeed not support joins .. but in the few cases I at first = used joins, i later realized i could just as well do without. regards, Lukas Kahwe Smith smith@pooteeweet.org