MySQL Join two tables in resultSet and add new coloum acording to first table

MySQL Join two tables in resultSet and add new coloum acording to first table

employee table
designation table

I want to show the designation in my result set from designation table.
and im searching data using nic. Help me Thank You