SQL query to select invoices with customer name

[omyha]

Hello !

 

I made an SQL query to list all invoices :

• id_order_invoice
• id_order
• total_products
• total_paid_tax_excl
• total_shipping_tax_excl
• total_paid_tax_incl
• date_add

select `id_order_invoice`, `id_order`, `total_products`, `total_paid_tax_excl`, `total_shipping_tax_excl`, `total_paid_tax_incl`, `date_add` from ps_order_invoice order by  `id_order_invoice` DESC

But I want to add these columns in the table :

• firstname and name of the customer
• the VAT amount
• VAT rate

 

 

I don't know how to join other tables to ps_order_invoice to do this :

• with id_order, we can get id_customer in ps_order
• and with id_customer, we can get firstname and lastname in ps_customer

 

But what I've tried didn't work... Someone to help me ?

 

Thanks everybody 

Alexis

Edited September 18, 2014 by omyha (see edit history)

[tuk66]

The query is at

http://www.prestashop.com/forums/topic/360900-requ%C3%AAte-sql-pour-sortir-les-factures-avec-le-nom-du-client-et-le-montant-de-la-tva/?do=findComment&comment=1803919