Lengkap

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

Kemahiran: Pelayan Microsoft SQL, Kejuruteraan Perisian, SQL

Lihat lagi: 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

Tentang Majikan:
( 5 ulasan ) Jeddah, Saudi Arabia

ID Projek: #17319654

Dianugerahkan kepada:

johnosullivan

jggjghjgjhghjgjhghgdghcyxrcuryuryiuhhkuuhhuihuihiuhiuhiuhiuhuihiuhiuhiuhuihiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuh

$15 USD dalam sehari
(33 Ulasan)
5.3

10 pekerja bebas membida secara purata $15 untuk pekerjaan ini

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 dalam 0 hari
(74 Ulasan)
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 dalam sehari
(208 Ulasan)
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 dalam sehari
(7 Ulasan)
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 dalam 0 hari
(1 Ulasan)
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 dalam sehari
(1 Ulasan)
2.6
Saumeh19

I can do that for you

$10 USD dalam sehari
(3 Ulasan)
2.8
$17 USD dalam sehari
(1 Ulasan)
0.5
$20 USD dalam sehari
(0 Ulasan)
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 dalam 0 hari
(0 Ulasan)
0.0