Færdiggjort

SQL Query required from epxert

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

Evner: Microsoft SQL Server, Software Arkitektur, SQL

Se mere: sql skills list, sql developer skills required, sql programmer job description, sql developer skill set, what does a sql developer do, basic sql skills, sql developer job requirements, sql job description example, sql parent child table tree query, access multi select form table, mysql php select query dropdown, select query view database names oracle 10g, dropdown select query, ajax select query, php display select query, populate drop php select query, select query drop, select query oracle, query failed mysql error 1065 query empty, sugarcrm query failed mysql error 1065 query empty

Om arbejdsgiveren:
( 5 bedømmelser ) Jeddah, Saudi Arabia

Projekt ID: #17319654

Tildelt til:

johnosullivan

jggjghjgjhghjgjhghgdghcyxrcuryuryiuhhkuuhhuihuihiuhiuhiuhiuhuihiuhiuhiuhuihiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuh

$15 USD på 1 dag
(33 bedømmelser)
5.3

10 freelancere byder i gennemsnit $15 på dette job

WebInfoSolutions

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 dage
(74 bedømmelser)
6.5
rohitagarberg

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 på 1 dag
(208 bedømmelser)
6.2
vdvaxel

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 på 1 dag
(7 bedømmelser)
3.5
farhadmammadli

I can easily solve the task for free right now. Contact for details I am a new freelancer, that is why I won't bid much. I have 3 years of experience in the field, and I guarantee high-quality work for you

$15 USD in 0 dage
(1 bedømmelse)
3.4
bitscollisionpk

Hey, I am expert in SQL Queries. Can you please give me your data? I will make your query which will work.

$10 USD på 1 dag
(1 bedømmelse)
2.6
Saumeh19

I can do that for you

$10 USD på 1 dag
(3 bedømmelser)
2.8
$17 USD på 1 dag
(1 bedømmelse)
0.5
$20 USD på 1 dag
(0 bedømmelser)
0.0
brightstar928

Hi, I have just read your description. If hire me, I fix it within an hour. I'm very interested in working with you. I look forward to speaking with you. Sincerely.

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