select PROJE.AD ,ISGUCU.islem1 as work1 ,ISGUCU.islem2 as work2, ISGUCU.islem3 as work3 from ISGUCU inner join PROJE on ISGUCU.PROJE_ID=PROJE.ID
select detay,ad from ( select ISGUCU.islem1 ,ISGUCUislem2 ,ISGUCU.islem3 from PERSONEL inner join ISGUCU on PERSONEL.ID=ISGUCU.PERSONEL_ID inner join PROJE on ISGUCU.PROJE_ID=T_PROJE.ID )as sorun unpivot ( ad for detay in (islem1 islem2,islem3 ) )AS DEVAM
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)