On Thu, 18 Feb 2010, P Kishor wrote: > SELECT l.llid, l.name, SUM(s.endKM - s.beginKM) AS distance > FROM lotic AS l JOIN streamlength AS s ON l.llid = s.llid > WHERE l.llid = '1226038453652' > GROUP BY l.llid, l.name
Thank you. Now I know. Much appreciated, Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
