SELECT t1.Name,t1.Faculty,t1.Year,t2.RegNo FROM table1 t1, table2 t2 WHERE t1.Name = t2.Name;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)