Hi All,

this article helps a lot to get an idea of solving my problems regarding sql-server data. my query looks like this:

SELECT

Company.UnternehmenName,

Company.UnternehmenID,

Department.Bereichname,

...