I really need help with this,
this is the scenario, i am trying to list all students with SID, lname, fname, year term, program name
Now here is the trick part, students can go to the same program more than one year..so when I run the query, it will list for me the student twice..
Now I want to create a query that wont list the student twice who attended the same program twice. AND I still want it to list student twice or more if he attended different program or so..
so yeah, what is the keyword in the query that will let me only select the students who went abroad with no year and programname match!