Find more Web Development Remote Jobs posted recently Worldwide

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

Posted at - May 17, 2024

Toogit Instant Connect Enabled


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.

About the recuiterMember since Nov 11, 2022 Amit Mustafi
from Texas, United States

Skills & Expertise Required

MySQL Programming sql Database mysql 

Open for hiringApply before - Aug 15, 2024

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$95.82
Cost

Offer to work on this project closes in 42 days!
Are you interested in this Opportunity?

Apply Now

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Web Development category.


Related Jobs


Latest In MySQL Programming Jobs


Latest In sql Jobs


Latest In Database Jobs


Latest In mysql Jobs