No problem. As a side note, it appears that you might also want to use group_concat on either hostName or remoteWXType too, but I can't quite tell 100%. As it stands right now, if there are multiple distinct values in the group, sqlite will arbitrarily choose one single value to represent the entire group (unless you use group_concat).
On Tue, Feb 17, 2009 at 11:29 PM, Joanne Pham <joannekp...@yahoo.com> wrote: > Thank a lot David! > It worked. > This is exatcly sql statement that I want to have. > Once again thanks a ton David, > JP _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users