select g.Enquiryfor,a.CustomerName, b.SiteName, c.TowerName, e.Floor,d.FlatsName, f.Area_Sqft, e.CreatedDate as BookedDate,e.SiteID,e.TowerID, e.FlatID, a.CustomerId,f.BookingID, e.EnquiryId from AdvitPM_Customer a,AdvitPM_SiteMaster b, AdvitPM_TowerMaster c, AdvitPM_FlatsMaster d, AdvitPM_Booking e, AdvitPM_BokkingDetails f, AdvitPM_Enquiry g where e.CustomerID = a.CustomerID and e.SiteID = b.SiteID and e.TowerID = c.TowerID and e.FlatID =d.FlatID and e.Status ='True' and e.BookingStatus = 'Enquired' and e.Booking_Id = f.BookingID and g.EnqId = e.EnquiryId and e.CreatedDate >= #" + objBo.FromDate + "# and e.CreatedDate <= #" + objBo.ToDate + "#
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)