SELECT A.subjcode, B.subjname1, section, RTRIM(Prenm1)+poname,time, room 
FROM  TSchedule A 
		INNER JOIN Tcourse B ON (A.subjcode = B.subjcode)
		INNER JOIN Teacher C ON (A.tea_sname = C.sname)
WHERE term = '2/2552' and (id_group like '51%') and 
	  SUBSTRING(id_group,5,3) = (SELECT id_program FROM TMajor 
							     WHERE prg_tname = 'ΗΤΘΗ‘ΓΓΑ«ΝΏ΅μαΗΓμ')