Mysql -> getting results from two tables?

[eluser]Johan André[/eluser]
Hey!

No problem! I like to help!

Code:

SELECT
    *,
    (SELECT SUM(invoices.amount) FROM invoices WHERE invoices.due_date < NOW() AND invoices.user_id = users.id) AS total_amount_due,
    (SELECT SUM(invoices.amount) FROM invoices WHERE invoices.user_id = users.id) AS total_amount
FROM
    users
LEFT JOIN
    invoices ON users.id = invoices.user_id
GROUP BY
    users.id
ORDER BY
    users.username ASC

This code will list all your users. "total_amount_due" is the total of all invoices due. "total_amount" is the total of all invoices (including the ones that past the due-date). If a user does not have any invoices the "total_amount_due" and "total_amount" will be NULL.