Joining Two query
select
a.Enquiry_Id,a.Ckeck_In,a.check_Out,a.Hotel_Name,a.Meal_Plan,a.Room_Type,a.Occupancy_Type,a.Room_QT,a.Adults
from Accomodation a
where a.Enquiry_Id = 74
select q.Enquiry_Id,q.Start,q1.Stay_At from Quick_Plan q,Quick_Plan q1
where q.Enquiry_Id = 74 and q1.Enquiry_Id = 74 and q.Stay_At = q1.Start
result of 1st query is
74 2013-08-03 2013-08-04 ADS CP deluxe Double 1 2
and the result of 2nd query is
74 Ahmedabad Agra
nw i want to combine these two query so that i get the result like
74 2013-08-03 2013-08-04 ADS CP deluxe Double 1 2
Ahmedabad Agra
No comments:
Post a Comment