Query 1 zu n

[Leuselator]

Also dann:

SQL-Code:

         select * 
           from dbo.Demo1 as A 
left outer join (  select 
                       Top 1 
                           *
                      from dbo.Test1
                  order by FeldNameNachDemTest1SortiertWerdenSoll
                ) as B
             on B.TestDemID=A.DemID