multiple tables in select query

[admin]

hello there.

my query string is

$query = "select sport.*, nyheter.* from sport,nyheter";

When i want to print the 'ingress' column for every record, i use :

while($myrow = mysql_fetch_array($result))
{
echo $myrow["ingress"]."<br><br>";
}

but, in the script, it shows the two records in table "nyheter", 8 times. So, i get 16 lines containing 2 records. Get it ?

What command would anyone suggest me to use ?

Thanks.
en0j.
Ps. Have also tried select * from nyheter,sport;