Support: Sample SQL statements

Does anyone have any sample sql statements that will give a report of customer name, invoice date, products, quantity, total, and whether it has been paid? I cannot seem to get any of my sql to work right.

Here is what I have. It does not seem to be working right though. I am using custom field 3 for mileage.

SELECT si_invoices.date, si_customers.name, si_customers.custom_field3, si_invoice_items.quantity, si_invoice_items.unit_price, si_invoice_items.total, si_invoice_items.product_id, si_account_payments.ac_payment_type, si_account_payments.ac_amount
FROM ((si_account_payments INNER JOIN si_customers ON si_account_payments.id = si_customers.id) INNER JOIN si_invoice_items ON si_account_payments.id = si_invoice_items.id) INNER JOIN si_invoices ON si_account_payments.id = si_invoices.id
ORDER BY si_invoices.date;