two sql tables with ID fields - how to change the name of one?

[Floezen]

I'm having two tables (kabul_fotos and kabul_fotos_kat), both have a field "id". I need to call the id field of only one table (kabul_fotos) to edit the right data set.

--
I calling the mySQL database:

$result = @mysql_query("SELECT * FROM kabul_fotos, kabul_fotos_kat WHERE kabul_fotos.kat_id=kabul_fotos_kat.id Order by datum"); 

[...]
And want to edit the right set:

<?="<a href='edit.php?id=$id'>Edit</a>"?>

--

The problem is, that it shows me the ID of the wrong table (kabul_fotos_kat)...

Thus I tried to rename the ID field of one table like this:

$result = @mysql_query("SELECT * kabul_fotos.id AS foto_id FROM kabul_fotos, kabul_fotos_kat WHERE kabul_fotos.kat_id=kabul_fotos_kat.id Order by datum"); 

But it seems like this is not the right way... "kabul_fotos.id AS foto_id" dosn't work.

Can someone help me - how do I do this?

Thanks
Flözen