Easy SQL query

I gang Opslået 6 år siden Betalt ved levering
I gang Betalt ved levering

I have 2 tables:

1. Products - columns: productid, productcode, quantity, time

2. Prices - columns: productid, price

I need an SQL query where I provide productcode and the query will UPDATE quantity, time and price (quantity and time in table1 and price in table2) (for the product with the productcode that I provided).

Thank you

MySQL

Projekt ID: #14331660

Om projektet

29 bud Remote projekt Aktiv 6 år siden

29 freelancere byder i gennemsnit $23 timen for dette job

Sonicoders

I have more than 3 years experience in the web development I can provide you the solution quickly inbox me,we can talk more over chat. Relevant Skills and Experience MYSQL Proposed Milestones $20 USD - pay me after I Flere

$20 USD på 1 dag
(86 bedømmelser)
5.7
Gates777

Hello, how are you? I can build your query for you in time. Please award me then I will finish it in 10mins and even will implement this on your website or anything other. I am waiting you. Thanks. Relevant Skills an Flere

$25 USD in 0 dage
(14 bedømmelser)
5.4
artifexonline

Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS ,Payment gateway, Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, AP Flere

$55 USD på 1 dag
(10 bedømmelser)
4.8
kunashe

Hi! I would be happy to build the query for you. Please let me know if you can share access to your database so I can test. Regards, Ku Relevant Skills and Experience SQL, MySQL Proposed Milestones $30 USD - Init Flere

$30 USD in 0 dage
(12 bedømmelser)
4.2
xyzrkt

HI, I read your requirements and i am sure that i will solve your problem. Relevant Skills and Experience I have experienced in MYSQL. Proposed Milestones $20 USD - Project MIlestone Thank you

$20 USD på 1 dag
(16 bedømmelser)
4.2
pankajsaini1989

You have 2 tables ( Products and Prices). You need SQL query where you provide productcode and the query will UPDATE quantity, time and price . Relevant Skills and Experience I have good experience of 5 years in My Flere

$30 USD på 1 dag
(3 bedømmelser)
2.9
pramsweety

Dear, Thank you for posting a job on my favorite technology i.e., Microsoft SQL Server. I have been working with Microsoft SQL server for the past 5 years in ERP, Big Data and Data warehousing environment. I have b Flere

$30 USD på 1 dag
(3 bedømmelser)
2.8
HackStarSJ

I write best sql queries for you lets start discuss about your tables Relevant Skills and Experience mysql,sql,mssql Proposed Milestones $20 USD - I write queries for you Please discuss your tables

$20 USD på 1 dag
(0 bedømmelser)
0.0
JohnJonas32

Hi. As a senior web developer I can implement your requirement perfectly. Relevant Skills and Experience MySQL, SQL Proposed Milestones $25 USD - SQL Query

$25 USD på 1 dag
(0 bedømmelser)
0.0
hassannaweed4

A proposal has not yet been provided

$11 USD på 1 dag
(0 bedømmelser)
0.0
Shailesh12345

Hi I'm DBA, it will hardly take 1 hour to complete your requirement. I hope you will contact to accomplish the task. Have good day. Relevant Skills and Experience I am DBA and I'm using multiple database for my variou Flere

$10 USD på 1 dag
(0 bedømmelser)
0.0
iserveradm

I had read your description and can easily help you out. Regrards. Relevant Skills and Experience Expert in MySQL Proposed Milestones $25 USD - phase 1

$25 USD på 1 dag
(0 bedømmelser)
0.0
vw7499303vw

Salut, Te pot ajuta cu acest query si cu altele daca ai nevoie, scrie-mi si te ajut cum pot. Mersi, Bogdan

$10 USD på 1 dag
(0 bedømmelser)
0.0
erdemartan

with one query update two tables Relevant Skills and Experience mysql Proposed Milestones $15 USD - finish

$15 USD på 1 dag
(0 bedømmelser)
0.0
jewelaj

Hi, i can provide you the SQL query you wanted. Relevant Skills and Experience I have done many sql based work. Proposed Milestones $10 USD - i will work for you

$10 USD in 0 dage
(0 bedømmelser)
0.0
SeanRajapakse

any and all queries needed. Relevant Skills and Experience I am a software engineering student and have studied in detail SQL and databases Proposed Milestones $10 USD - get all queries done Additional Services Offe Flere

$10 USD på 1 dag
(0 bedømmelser)
0.0