On Aug 13, 2014, at 3:43 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
> I don't think you want max() around collections.book_in_date. You want the > max(collection_date) but the book_in_date from that row. Since the > collection_date is unique, the book_in_date can only come from one record. Possibly. Surely the OP knows her data. On the other hand, this being an aggregation, every keys must be accounted for. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
