Hi!
I just can't figure out how to re-write this Query so that it fits mySql, can someone plz help me!!!
SELECT * FROM Object WHERE name NOT IN((SELECT objectName FROM Booking WHERE startDate >= ? AND startDate < ? OR stopDate > ? AND stopDate <= ? OR startDate <= ? AND stopDate >= ?))
Obove String is a PreparedStatement, which means that the ?:s will be exchanged with appropriate values!!
Anyone??? Thanx // Kowalski
I just can't figure out how to re-write this Query so that it fits mySql, can someone plz help me!!!
SELECT * FROM Object WHERE name NOT IN((SELECT objectName FROM Booking WHERE startDate >= ? AND startDate < ? OR stopDate > ? AND stopDate <= ? OR startDate <= ? AND stopDate >= ?))
Obove String is a PreparedStatement, which means that the ?:s will be exchanged with appropriate values!!
Anyone??? Thanx // Kowalski