# 1965. Employees With Missing Information

<https://leetcode.com/problems/employees-with-missing-information>

## Description

Table: `Employees`

```
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| employee\_id | int     |
| name        | varchar |
+-------------+---------+
employee\_id is the primary key for this table.
Each row of this table indicates the name of the employee whose ID is employee\_id.
```

Table: `Salaries`

```
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| employee\_id | int     |
| salary      | int     |
+-------------+---------+
employee\_id is the primary key for this table.
Each row of this table indicates the salary of the employee whose ID is employee\_id.
```

Write an SQL query to report the IDs of all the employees with **missing information**. The information of an employee is missing if:

* The employee's **name** is missing, or
* The employee's **salary** is missing.

Return the result table ordered by `employee_id` **in ascending order**.

The query result format is in the following example:

```
Employees table:
+-------------+----------+
| employee\_id | name     |
+-------------+----------+
| 2           | Crew     |
| 4           | Haven    |
| 5           | Kristian |
+-------------+----------+
Salaries table:
+-------------+--------+
| employee\_id | salary |
+-------------+--------+
| 5           | 76071  |
| 1           | 22517  |
| 4           | 63539  |
+-------------+--------+
Result table:
+-------------+
| employee\_id |
+-------------+
| 1           |
| 2           |
+-------------+
Employees 1, 2, 4, and 5 are working at this company.
The name of employee 1 is missing.
The salary of employee 2 is missing.
```

## ac

```java
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://jaywin.gitbook.io/leetcode/solutions/1965-employees-with-missing-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.