[SQL bzw. TSQL] Komplizierte SQL Anweisung

[mkinzler]

SQL-Code:

select 
    distinct t1.nr, 
    t2 Description 
from 
    mytable t1 
        join mytabel t2 pn t2.nr = t1.nr
where
    t1.company in (60,90)
order by
    t1.nr, t1.company;