Query SELECT t.admission_id, t.rollno, t.stud_full_name, c.college_name, b.branch_name FROM tbl_admission t INNER JOIN tbl_college c ON t.allotted_college_code = c.college_code INNER JOIN tbl_admission_branch b ON b.branch_id = t.allotted_branch

Sl.No.	Rollno	Name of Candidate	College	Course/Branch
1	6681477782	JAGANNATH BALAVANANDA DASH	DRIEMS Business School, Cuttack	PGDM
2	6041478362	BIBEK RANJAN BHOI	DRIEMS Business School, Cuttack	PGDM
3	6671479836	DIPTI RANJAN DASH	DRIEMS Business School, Cuttack	PGDM

JEE-2011, ORISSA