I have three tables (users, books, pencils) and would like to get a list of all users with a count and total price of their books and pencils for 2012-01-01...
So with this data... users (user_id) 1 2 3 books (user_id, price, created) 1 | $10 | 2012-01-01 1 | $10 | 2012-01-01 3 | $10 | 2012-01-01 pencils 1 | $.50 | 2012-01-02 3 | $.50 | 2012-01-01 3 | $.50 | 2012-01-02 What is the most efficient way to get this result... query_result (user_id, book_count, book_price_total, pencil_count, pencil_price_total) 1 | 2 | $20 | 0 | $0 2 | 0 | $0 | 0 | $0 3 | 1 | $10 | 1 | $.50 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
