Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Gary Stainburn'" <gary.stainburn@ringways.co.uk>,
	<pgsql-sql@postgresql.org>
Subject: Re: gone blind - can't see syntax error
Date: Fri, 1 Apr 2005 17:21:10 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcU2sJAeO94gkVVcRsKBN5p+P23WJAAAH1QQ
In-Reply-To: <200504011236.00974.gary.stainburn@ringways.co.uk>
Message-Id: <20050401115403.6B79B53223@svr1.postgresql.org>

Try this


FROM requests r
left outer join users sm on sm.u_id = r.r_salesman
left outer join users u on r.r_u_id = u.u_id
left outer join request_types t on r.r_t_id = t.t_id
left outer join request_states s on r.r_s_id = s.s_id
left outer join dealerships d on r.r_d_id = d.d_id
left outer join departments de on r.r_de_id = de.de_id
left outer join customers c on r.r_c_id = c.c_id
left outer join comment_tallies co on r.r_id = co.r_id ORDER BY r.r_id;


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Gary Stainburn
Sent: Friday, April 01, 2005 5:06 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] gone blind - can't see syntax error

Hi folks.

I've been looking at this for 10 minutes and can't see what's wrong.  
Anyone care to enlighten me.

Thanks

Gary

[httpd@stan webroot]# psql -a -f new-view.sql SELECT r.r_id,
r.r_registration, r.r_chassis, r.r_vehicle, r.r_fuel, r.r_pack_mats,
r.r_delivery,
        (date(r.r_delivery) - date(now())) AS r_remaining, r.r_created,
r.r_completed, r.r_salesman,
        sm.r_salesman as salesman_name,
        d.d_des, de.de_des,
        u.u_id, u.u_userid, u.u_username, u.u_salesman, u.u_target,
        t.t_id, t.t_des,
        s.s_id, s.s_des,
        c.c_id, c.c_des,
        co.com_count, co.com_unseen
FROM requests r,
left outer join users sm on sm.u_id = r.r_salesman, left outer join users u
on r.r_u_id = u.u_id, left outer join request_types t on r.r_t_id = t.t_id,
left outer join request_states s on r.r_s_id = s.s_id, left outer join
dealerships d on r.r_d_id = d.d_id, left outer join departments de on
r.r_de_id = de.de_id, left outer join customers c on r.r_c_id = c.c_id, left
outer join comment_tallies co on r.r_id = co.r_id ORDER BY r.r_id;
psql:new-view.sql:19: ERROR:  parser: parse error at or near "left"

--
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     


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster