How the execution flow happen in Inheritance.

Question

Today i attend a interview , interviewer asked a question . I gave all possible answer but interviewer is not satisfied. So I though I put this question here... Suppose we have a base class and child class how the execution flow in back end and how calls happen. Class a { // No variable n methods inside base class } Class B : A { // No variable n methods inside Child class } Suppose if we run this code what will happen in terms of execution flow. Thanks in advance. Please suggest me idea about inheritance execution flow.

Answer 1

SELECT Empid,Empname,Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid

This is the best code.

Answer 2

SELECT Empid,
            Empname,
            Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid