ANavn cannot be null see http://www.cyren.no/diagram3.gif 

Shall i only put the

            SELECT DISTINCT GjelderFra FROM marsh_HKL.tblhertzkorttidsleiebiler,

                        LEFT JOIN marsh_HKL.tblhertzkorttidsleieAvdeling 

                               ON FKBRAvdeling=AID --AND GjelderFra BETWEEN @datoFOM and @dataTOM

in the first select or both?

With this i get error:

*******************************

Incorrect syntax near the keyword 'LEFT'

*******************************