Find Jobs
Hire Freelancers

CREATE ONE ARTICOLATE SQL QUERY TO SOLVE THE FOLLOWING PROBLEM

$30-250 USD

Completed
Posted almost 4 years ago

$30-250 USD

Paid on delivery
I HAVE 3 SQL TABLES, 2 IS THE TABLET OF PRESTASHOP = TABLET ORDERS AND TABLE ADRESS AND ONE IS ANOTHER TABLE WITH OTHER DATA CALLED PAYMENT I NEED TO DO THIS INTERROGATION TO THE DATABASE, IF THE COLUNN 'MARK' IS DIFFERENT FROM '1' IN TABLE ORDERS, UPDATE HIS VALUE WHERE FROM THE RESULT OF THE UNION OF THE TABLET ORDERS AND ADRESS WITH THE CONDITION THAT [login to view URL] = [login to view URL] COMPARE ( [login to view URL] + [login to view URL] ) WHEN IS SAME AS [login to view URL] IN THIS CASE SET [login to view URL] 1 AND ALSO [login to view URL] = 1 I KNOW I AM BEEN LITTLE BIT MESSY, I HOPE YOU UNDERSTAND MY REQUEST THANKS
Project ID: 25067548

About the project

9 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am Lazar and have got heavy experience in mysql. I have done many large database handling projects so I have ever control the messy query statements. I will give you the best result. Please send me a message so that I will help you. Regards
$50 USD in 7 days
4.9 (5 reviews)
3.6
3.6
9 freelancers are bidding on average $101 USD for this job
User Avatar
DEar sir. Nice to meet you. AS you know seeng my profiels and reviews, I am php/myspl expert. If you give me a chance, I will show you good project on time. Thanks. Natalya.
$100 USD in 5 days
4.9 (32 reviews)
6.2
6.2
User Avatar
Dear Concern I work in prestashop and have a rich experience int this area. Have a time to chat with me? I am available to talk with u. Thanks Suman
$140 USD in 3 days
4.8 (111 reviews)
5.9
5.9
User Avatar
Hello I hope all's well with you. If you'r looking for a developer proficient in Ms Access/SQL then you can read:. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a view what/how I can code for your project via Ms Access. Besides, I can provide access to any my MS Access application. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$140 USD in 7 days
4.9 (13 reviews)
5.2
5.2
User Avatar
I have more then 15 years of experience in SQL Server databse design, modeling, development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I can join immediately.
$111 USD in 1 day
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi there, I'm a senior data warehouse consultant with over 6 years of experience in data modeling for enterprise level database system in Retail domain. I have a strong background in database and SQL and I believe i can help you with your project. Please feel free to check my profile for professional experience and please feel free to contact. Looking forward to hearing from you. Regards, Udeep
$100 USD in 2 days
5.0 (4 reviews)
3.2
3.2
User Avatar
Dear Sir, I am a professional freelancer and a SQL expert. You can easily rely on me. Please visit my profile.
$30 USD in 1 day
5.0 (5 reviews)
2.6
2.6
User Avatar
In my personal experience being the one conducting interviews, when I ask this question, what I have in mind is to measure the confidence level of the person and reasoning skills. You may need to brag a little about yourself and compare your skills and experiences to others. You need to convince me that you are indeed an asset and you’re exactly the person suited to accomplish this project.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have experience in filtering data from clients with thousands of rows using SQL Server. I'm sure I can help with your SQL problem. I may need extra information regarding your problem if you accept my bid.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Villorba, Italy
5.0
3
Payment method verified
Member since Feb 5, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.