Đã hoàn thành

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

Kĩ năng: Microsoft SQL Server, Kiến trúc phần mềm, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Jeddah, Saudi Arabia

ID dự án: #17319654

Được trao cho:

johnosullivan

jggjghjgjhghjgjhghgdghcyxrcuryuryiuhhkuuhhuihuihiuhiuhiuhiuhuihiuhiuhiuhuihiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuh

$15 USD trong 1 ngày
(33 Đánh Giá)
5.3

10 freelancer đang chào giá trung bình $15 cho công việc này

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 trong 0 ngày
(74 Nhận xét)
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 trong 1 ngày
(208 Nhận xét)
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 trong 1 ngày
(7 Nhận xét)
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 trong 0 ngày
(1 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
2.6
Saumeh19

I can do that for you

$10 USD trong 1 ngày
(3 Nhận xét)
2.8
$17 USD trong 1 ngày
(1 Nhận xét)
0.5
$20 USD trong 1 ngày
(0 Nhận xét)
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 trong 0 ngày
(0 Nhận xét)
0.0