[käptn]

SELECT tbl1.fld1 as ich, tbl2.fld2 as du 
FROM tbl1 LEFT JOIN tbl2 USING(id) 
WHERE tbl1.id = 123

PHP-Code:

$row = mysql_fetch_object($rs);
$ich = $row->ich;
$du  = $row->du; 


~