Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dude131
Starting Member
6 Posts |
 Posted - 2005-07-01 : 16:01:42
|
| Can someone help me combine these 2 queries, so instead of statement 2 relying on statement 1, it is just one complete statement I can run in ASP. Thanks for any suggestions!@!!Statement1 (Query name in MS Access is Rooms Reserved):strSQl = "SELECT Booking.BookPropID, Booking.BookDateStart, Booking.BookDateEnd FROM Booking WHERE (((Booking.BookDateStart) Between #" & cindate & "# And #" & coutdate & "# -1)) Or ((([BookDateEnd]-1) Between #" & cindate & "# And #" & coutdate & "#)) Or (((Booking.BookDateStart)<#" & cindate & "#) And (([BookDateEnd]-1)>#" & coutdate & "#-1))"Statement2 (Bolded reference to first query):strSQL2 "SELECT Property.PropID FROM Property LEFT JOIN [Rooms Reserved] ON Property.PropID=[Rooms Reserved].BookPropIDWHERE ((([Rooms Reserved].BookPropID) Is Null))" |
|
|
dude131
Starting Member
6 Posts |
Posted - 2005-07-01 : 16:10:00
|
| Resolved here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51834 |
 |
|
|
|
|
|
combine 2 statements