Dear sir
Goodmorning.
I have two table, one is TBL_EMP and second is TBL_DEPARTMENT
TBL_EMP
EMPID, DEPTID, EMPNAME, DOJ, DOB .....
TBL_DEPARTMENT
DEPTID, DEPTNAME
DEPTNAME are executive, developer
I have require empID ex1001, dev1002, and so on.............