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

MYSQL UNION SELECT NULL


2007-08-27 Digg! icurtain Delcious icurtain
  1. SELECT * FROM  
  2. crh_houses  
  3. LEFT JOIN  
  4. crh_p_tags 
  5. ON  
  6. crh_houses.house_id = crh_p_tags.house_id 
  7. WHERE 
  8. crh_houses.house_id = 3  
  9. UNION DISTINCT 
  10. SELECT  
  11. *,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL 
  12. FROM  
  13. crh_p_tags WHERE crh_p_tags.house_id = 3