i have two join two table and select distinct row using the order of emp date of joining
Not too sure, but sounds like you need this:
SELECT
mstEmployees.empid,
mstEmployeesDetails.empname,
mstEmployeesDetails.empclient,
mstEmployeesDetails.empstatus
FROM
mstEmployees
INNER JOIN
mstEmployeesDetails ON mstEmployees.empid = mstEmployeesDetails.empid
ORDER BY
mstEmployeesDetails.empdoj