SQL

$query = "SELECT `service`.idn AS id, `worklist`.workname AS workname FROM `service` , `worklist` WHERE `worklist`.idrep = `service`.idn";

$result = mysql_query($query);

while($row = mysql_fetch_array($result))

{

echo $row["id"]." - ".$row["workname"];

echo <br>;

}