Consider a scenario where you have an "Employee" table containing a "deptid" as a foreign key linked to a "Department" table. Write an SQL statement with an explicit INNER JOIN that retrieves and displays information. Include details such as employee names, department names, and any other relevant attributes. Discuss the significance of using an INNER JOIN in this context and how it ensures accurate and meaningful results from the query.