________________________________
From: Pete <p...@mollysrevenge.com>
To: sqlite-users@sqlite.org
Sent: Fri, April 8, 2011 3:31:05 AM
Subject: [sqlite] GROUP BY Problem
>SELECT c1,c2,sum(t2.c3),count(t3.c4) FROM t1 LEFT JOIN t2 on t2.key2=t1.key1
>LEFT JOIN t3.key3=t1.key1 GROUP BY t1.key1
Shouldn't the second JOIN be
LEFT JOIN t3 ON t3.key3=t1.key1 ?
Marian Cascaval
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
