public ListView GetAllCand(ListView appGridView) { yourString = "Select s.stud_id as Student_id,c.candidate_id as Candidate_id,s.last_name||', '||s.first_name as Full_name ,a.position_name as position from student s,candidate c,all_positions a where s.stud_id = c.student_id and c.position_id = a.position_id;"; return(query.ViaListView(yourString, appGridView)); }