Mine

select * from table1 left join table2 on table1.id = table2.other_id<!-- <div id="contentfeatured">//	<h1>Featured Properties</h1>//	<p>All ourms.</p></div> --><div id="contentfeatured">	<h1>Featured Properties</h1><?php$r = mysql_query("SELECT f.id, f.property_id, p.image_copy, f.title, p.title as property_title, p.property_code, f.description, left(p.short_description, 57) as short_description, p.bedrooms, f.link_url FROM featured_properties f left join featured_properties_to_web_sites on featured_property_id = id left join properties p on f.property_id = p.id WHERE property_id != 0 AND f.location_id IN ($location) ORDER BY sort_order ASC LIMIT 3");If (mysql_num_rows($r) > 0) {	$where = " location in ($location) ";?><script language="JavaScript"><!--function MM_jumpMenu(targ,selObj,restore){ //v3.0  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");  if (restore) selObj.selectedIndex=0;}//--></script><style>.jumpmenu { background-color: #FFFFFF; color: #000000; font-weight: normal; font-family: Arial, Helvetica, sans-serif; font-size: 8pt; width: 150px; margin-top:2px;}div#featured {	width: 150px;	float: left;	overflow:hidden;	display: block;	margin: 1px 5px 1px 1px;	padding: 0px 0px 1px 1px;}div#featuredhotel {	width: 150px;	float: left;	overflow:hidden;	display: block;	margin: 1px 5px 1px 1px;	padding: 0px 0px 1px 1px;}div#featuredcondo {	width: 150px;	float: left;	overflow:hidden;	display: block;	margin: 1px 5px 1px 1px;	padding: 0px 0px 1px 1px;}div#featuredhome {	width: 150px;	float: left;	overflow:hidden;	display: block;	margin: 1px 0px 1px 1px;	padding: 0px 0px 1px 1px;}</style><?	$i = 0;	while($rw = mysql_fetch_array($r))	{			If ($rw['image_copy'] != 0){		  $image = "/images/property/".GetImageFolder($rw['image_copy'])."/".$rw['image_copy']."-1.jpg";		}else{		  $image = "/images/property/".GetImageFolder($rw['property_id'])."/".$rw['property_id']."-1.jpg";		}		?>	<div id="featured"><?							$beds = '';		$valid_beds = '';		$result = mysql_query("SELECT id FROM properties WHERE ".$where." AND property_code = '".$rw['property_code']."' ORDER by bedrooms asc") or die("SELECT Query failed: " . mysql_error());		//Echo "SELECT id FROM properties WHERE ".$where." AND property_code = '".$rw['property_code']."' ORDER by bedrooms asc";		If (mysql_num_rows($result) > 1) {			While($row = mysql_fetch_array($result)){				$valid_beds .= $row['id'].',';			}			$beds = substr($valid_beds, 0, -1);		}else{			$row = mysql_fetch_array($result);			$beds = $row['id'];		}$p1 = $rw['property_title'];if (strlen($p1) > 28) { $pi = substr($p1, 0, 27) . '..'; } ?>	<a href="<? If (trim($rw['link_url']) == '') { Echo "/results.php?location=".$location."&featured=".$beds; }else{ Echo $rw['link_url']; } ?>" class="link"><img src="<?=$image;?>" height="107" width="150" align="left" border=0/></a>	<p><a href="<? If (trim($rw['link_url']) == '') { Echo "/results.php?location=".$location."&featured=".$beds; }else{ Echo $rw['link_url']; } ?>" class="link"><? If (trim($rw['title']) == '') { Echo $pi; }else{ Echo $rw['title']; } ?></a>	<a href="<? If (trim($rw['link_url']) == '') { Echo "/results.php?location=".$location."&featured=".$beds; }else{ Echo $rw['link_url']; } ?>" class="link"></a></p><?	$f = mysql_query("SELECT distinct bedrooms FROM properties WHERE ".$where." AND property_code = '".$rw['property_code']."' ORDER BY bedrooms ASC");	If (mysql_num_rows($f) > 0) {	?><!--	<select name="menu1" class="jumpmenu" onChange="MM_jumpMenu('parent',this,0)">	        <option selected>Select Unit Type</option>	<?		while($fw = mysql_fetch_array($f))		{			$beds = '';			$valid_beds = '';			$result = mysql_query("SELECT id FROM properties WHERE ".$where." AND bedrooms = ".$fw['bedrooms']." AND property_code = '".$rw['property_code']."' ORDER BY bedrooms ASC") or die("SELECT Query failed: " . mysql_error());			If (mysql_num_rows($result) > 1) {				While($row = mysql_fetch_array($result)){					$valid_beds .= $row['id'].',';				}				$beds = substr($valid_beds, 0, -1);			}else{				$row = mysql_fetch_array($result);				$beds = $row['id'];			}		?>	        <option value="/results.php?location=<?=$location;?>&amp;bedrooms=<?=$fw['bedrooms'];?>&amp;featured=<?=$beds;?>"><?=PrintBedroomString2($fw['bedrooms']);?></option>		<?		}	?>	      </select> -->	<?			}?>	</div><?	$i++;}}if (!$where) { echo '<span class="text">Fo4</b>.</span>'; }?></div>