Required MySQL Programming,sql,Database,mysql freelancer for NLN Quick MySQL Join job

I have two tables. One is orders, one is order items. I will share it later

I need a join that will append the results of multiple rows of order items to the end of orders; keeping one row per order.

i.e. the final output should be in the following format :


id, order_id, order_date, source, order_status... (all fields in orders) ... shipstation_exported, shipstation_shipped_item_count, order_item_id_1, product_id_1, variation_id_1, qty_1, line_subtotal_1, line_total_1, order_item_id_2, product_id_2, variation_id_2, qty_2, line_subtotal_2, line_total_2, etc. (for each order item (max 10)...

Please use the word HIPPOGRIFF in the first sentence of your application...

so if there are 10 products in an order, there would be 10 instances of these column at the end (my sample had 4)



`order_id` int(11) DEFAULT NULL,
`order_item_id` int(11) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`variation_id` int(11) DEFAULT NULL,
`qty` int(11) DEFAULT NULL,
`line_subtotal` int(11) DEFAULT NULL,
`line_total` int(11) DEFAULT NULL


I need this completed earlier.

Skills & Expertise Required

MySQL Programming sql Database mysql