select a.ORGANSID,a.s_code,a.ORGAN,a.COUNTRYTxt,a.ORGANGUBUN,a.T_Field_U,s.department from TB_ORGAN_ALL a inner join registration_2014 s on a.s_code=s.s_code and s.actstatus=0 where a.ISDELETE='Y' and year='2014' and left(a.accessip,12)<>'118.128.115.' and ((a.COUNTRY='NATION168' and a.onOffChk='Y') or (a.COUNTRY<>'NATION168' and a.onOffChk='N')) and a.COUNTRYTxt='Slovenia' order by ORGANSID asc KOREA EUREKA DAY 2014
Matchmaking Guidelines
Search Organization
Apply E-Matchmaking
Organisation in 2013
Slovenia      
Technology Fields Organisation Type Organisation Name Country
No List