there's no difference in using alias or table name in your query, either should work.
select student_no,student.programme_code,programme_name
from student,programme
where student.programme_code=programme.programme_code
or
select student_no,s.programme_code,programme_name
from student...