$result=mysql_query('SELECT * FROM `tableA` inner join tableB on tableA.delivery=tableB.id');
while($row = mysql_fetch_array($result)){
echo $row['id'];}