Show me the details of newly joined employees based on two tables: the employee table and the salary table, where employee ID is the foreign key.

Retrieve newly joined employee details by joining employee and salary tables using Emp ID as the foreign key.

• Use SQL JOIN to combine employee and salary tables on Emp ID.

• Example SQL query: SELECT e.*,...read more

SELECT Employee.*, Salary.*

FROM Employee

INNER JOIN Salary ON Employee.EmpID = Salary.EmpID

ORDER BY Employee.JoiningDate DESC;