Forum

Write a sql query r...
 
Notifications
Clear all

Write a sql query resort located In jaipur display the resort name and the manager Name


Rahul Updhyay
Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 1 year ago

Write a query to display the resort name and its manager name for the resort located at jaipur. sort by resort name.

1 Reply
FA User
Posts: 36
 FA User
(@FA User)
Joined: 1 year ago

Here is the query to display the resort name and its manager name for the resort located at jaipur order by the resort name.

Select a.ResortName, b.name as ManagerName
From
Resort a,
Manager b
Where
a.managerID=b.managerID
AND
b.city= "JAIPUR"
Order by ResortName
Reply
Share: