How to add this query as a column in orders table

[Rodrigo Chantes]

 

i need to add a field of the customer's IP Address in the Orders table, i actually got the ip address query but i need to add it to that table, here's the query:

SELECT a.id_order, a.id_customer, b1.id_guest, c1.ip_address, c1.date_add, d1.email FROM ps_orders a LEFT JOIN ps_guest b1 ON (a.id_customer = b1.id_customer) LEFT JOIN ps_connections c1 ON (b1.id_guest = c1.id_guest) LEFT JOIN ps_customer d1 ON (a.id_customer = d1.id_customer)