Tamamlanmış

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

Beceriler: Microsoft SQL Server, Yazılım Mimarisi, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 5 değerlendirme ) Jeddah, Saudi Arabia

Proje NO: #17319654

Seçilen:

johnosullivan

jggjghjgjhghjgjhghgdghcyxrcuryuryiuhhkuuhhuihuihiuhiuhiuhiuhuihiuhiuhiuhuihiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuhiuh

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(33 Değerlendirme)
5.3

Bu iş için 10 freelancer ortalamada $15 teklif veriyor

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

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(74 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(208 Değerlendirme)
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?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
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

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
2.6
Saumeh19

I can do that for you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.8
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0