X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 38EC853245 for ; Fri, 1 Apr 2005 13:13:39 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92924-09 for ; Fri, 1 Apr 2005 12:13:38 +0000 (GMT) Received: from stan.ringways.co.uk (hub.ringways.co.uk [213.38.87.130]) by svr1.postgresql.org (Postfix) with ESMTP id BFCBE5324D for ; Fri, 1 Apr 2005 13:13:36 +0100 (BST) Received: from gary.ringways.co.uk ([10.1.1.2]) by stan.ringways.co.uk with esmtp (Exim 3.22 #1) id 1DHKxf-0005aV-00 for pgsql-sql@postgresql.org; Fri, 01 Apr 2005 13:09:15 +0100 Content-Type: text/plain; charset="utf-8" From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: Re: gone blind - can't see syntax error Date: Fri, 1 Apr 2005 13:08:00 +0100 User-Agent: KMail/1.4.3 References: <200504011236.00974.gary.stainburn@ringways.co.uk> <200504011731.07875.lawgon@thenilgiris.com> In-Reply-To: <200504011731.07875.lawgon@thenilgiris.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200504011308.00391.gary.stainburn@ringways.co.uk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/8 X-Sequence-Number: 20901 On Friday 01 April 2005 1:01 pm, you wrote: > On Friday 01 Apr 2005 5:06 pm, Gary Stainburn wrote: > > Hi folks. > > > > I've been looking at this for 10 minutes and can't see what's > > wrong. Anyone care to enlighten me. > > comma after 'r'? I'd only just added that comma, to try to fix it. That shouldn't have been there. The problem was the comma after each of the joins. They should not have been there either. Gary -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000