[H] PHP Get/Set PHP Linux Java[EE] Java[J2ME] SQL general Plymouth-University JSF Contact

MySql code - left join group by


2007-08-06 Digg! icurtain Delcious icurtain
  1. SELECT  
  2. * 
  3. FROM  
  4. holiday_dates  
  5. LEFT JOIN 
  6.  
  7. holiday_rentals  
  8. ON  
  9. holiday_rentals.week = holiday_dates.week 
  10.  
  11. AND holiday_rentals.house_id = 3 
  12.  
  13. GROUP BY holiday_dates.week