php Programming Glossary: f_lu_id
Searching for availability with MySQL (and PHP)? http://stackoverflow.com/questions/1687519/searching-for-availability-with-mysql-and-php LettingUnits ID Name etc... LettingUnitBookings ID F_LU_ID Start End Where F_LU_ID is a foreign key to the unit. What is.. Name etc... LettingUnitBookings ID F_LU_ID Start End Where F_LU_ID is a foreign key to the unit. What is the best way to search.. u LEFT OUTER JOIN LettingUnitBookings b1 ON u.ID b1.F_LU_ID AND b1.End BETWEEN @StartOfWindow AND @EndOfWindow LEFT OUTER..
|