Consulta cruzada de 4 tablas

[lynxstyle]

Si pero no funciona, quedó así.

Código MySQL:

SELECT ps_customer.id_customer, ps_customer.firstname, ps_customer.lastname,
address1, address2, city, postcode, phone, phone_mobile, product_name
FROM ps_customer INNER JOIN ps_address ON ps_address.id_customer=ps_customer.id_customer
INNER JOIN ps_orders ON ps_orders.id_customer=ps_customer.id_customer
INNER JOIN ps_orden_detail ON ps_order_detail.id_order=ps_orders.id_order ORDER BY postcode
 

No entiendo el INNER con ps_orden_detail por que no tiene relacion con la tabla ps_customer como las demás.