I have 2 tables say A and B.
Table A has EmpID, First Name and Last Name.
Table has Award Recipient, Award Presenter ID(EmpID format).
I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based on the Award Presenter ID from table B.
I believe I have to write inner join for this, but I have never written before. please help!