Find Jobs
Hire Freelancers

SQL Query required from epxert

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
I have an issue to query from same table to fetch some data select GuestNote,FName,LName,GuestID,[login to view URL] from Ondemands inner join Users on OnDemands.UserID=[login to view URL] where users.userid=3 and users.password='4201' and status='1' this return : FName,LName for userID=3 and return the GuestID which has FName,LName from same UserTable so I need to fetch FName,LName for the GuestID which is saved as userID in users Table
Project ID: 17319654

About the project

7 proposals
Remote project
Active 6 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
jggjghjgjhghjgjhghgdghcyxrcuryuryiuhhkuuhhuihuihiuhiuhiuhiuhuihiuhiuhiuhuihiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuh
$15 USD in 1 day
5.0 (34 reviews)
5.3
5.3
7 freelancers are bidding on average $15 USD for this job
User Avatar
Respected Sir, Can u please send the schema for the user and huest table? and some dummy data to test? Kind Regards Pankaj Garg
$15 USD in 0 day
4.9 (99 reviews)
6.8
6.8
User Avatar
hi sir, i will write the query right now that will fetch the FName,LName for the GuestID which is saved as userID in users Table
$10 USD in 1 day
5.0 (303 reviews)
6.6
6.6
User Avatar
Hi, I have very good knowledge of SQL queries so I'm sure I can help you out. Can we discuss details via chat please?
$25 USD in 1 day
5.0 (8 reviews)
4.0
4.0
User Avatar
Hey, I am expert in SQL Queries. Can you please give me your data? I will make your query which will work.
$10 USD in 1 day
4.9 (6 reviews)
4.2
4.2
User Avatar
I can do that for you
$10 USD in 1 day
4.1 (6 reviews)
2.9
2.9

About the client

Flag of SAUDI ARABIA
Jeddah, Saudi Arabia
5.0
21
Payment method verified
Member since Jul 4, 2006

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)
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.