How to join FirstName and LastName coming from related table in yii2 gridview with sorting and searching

Is there is any way in yii2 to join suppose two fields firstname and lastname from a related table into a single cell of gridview with sorting and searching ability.

I have a salary table and i want the firstname and lastname of an employee in the salary table( having the employee_id) in a single cell of gridview with searching and sorting ability.

Please help

Kartik wrote a great tutorial on this:

Kartik’s Tutorial

I think you’ll find it very useful.

Thanks for sharing, it solved my issue.