Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
SQL
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 + "#


this is my query and i am not getting the data?y..plse
Posted
Updated 1-Oct-12 0:31am
v2
Comments
Joan M 1-Oct-12 6:58am    
Hello Raju, you should definitely read the posting guidelines.

Throwing a code dump here will end always in tears.
What does it means that you are not getting the data?
Is it giving you any kind of error?
Is it giving you a partial data set?
Which database are you using and which software are you using?
...

1 solution

Copy and paste this query in SQL Server management studio and check if you can get any results.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900