On Mon, 6 Jan 2003, Gary Stainburn wrote: > create view turn_details as > select t.*, d.sid as dsid, d.sname as dname, > f.sid as fsid, f.sname as fname, > (select sum(r.rmiles) as rmiles from rides r where r.rtid = tid) > as rmiles > from turns t > left outer join staff d on t.tfitter = d.sid > left outer join staff f on t.tccleaner = f.sid > where r.rtid = t.tid > order by tdate; > ERROR: Relation 'r' does not exist
Do you really need the outer where r.rtid=t.tid? I would think that the subselect where clause would already handle that for you. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
