no hit: SELECT t1.nr, t1.art, t1.vikt, t1.namn, t1.datum, t1.poang, t2.Foto FROM fisk AS t1 LEFT JOIN foto AS t2 ON t1.nr=t2.Nr WHERE t2.Nr = '2007-08-04 Roding 5350.JPG';