$s = @mysql_query("select * from urunler as u, left join sirketler as s on u.sirketID=s.sirketID"); while($r = @mysql_fetch_assoc($s)): echo $r["urunadi"]." / ".$r["sirket_adi"]."\n"; endwhile;