来自多个表的 SQL 查询

Question

我是 SQL 新手，我需要一些帮助，

我想找出姓氏的确认(确认=1)预订日期Steven
有人可以帮助解决此 SQL 查询吗

table_member

+-----------+-----------+
|Member_id  | last_name |
+-----------+-----------+
| 1         | David     |
| 2         | owen      |
| 3         | Tom       |
| 4         | Steven    |
| 5         | Steven    |
| 6         | Steven    |
| 7         | Steven    |
| 8         | Steven    |
| 9         | Steven    |
+-----------+-----------+

table_resevation

+-----------+-----------+-----------+-----------+
|resvationID|Member_id  | day       |   month   |
+-----------+-----------+-----------+-----------+
| 1         | 1         |   1       |     6     |
| 2         | 1         |   2       |     6     |
| 3         | 2         |   1       |     6     |
| 4         | 4         |   1       |     6     |
| 5         | 4         |   2       |     6     |
| 6         | 5         |   1       |     6     |
| 7         | 5         |   2       |     6     |
| 8         | 7         |   3       |     6     |
+-----------+-----------+-----------+-----------+

确认

+-----------+-----------+-----------+
|confirmID  |resvationID| confirmed |
+-----------+-----------+-----------+
| 1         | 1         |   1       |
| 2         | 2         |   1       |
| 3         | 3         |   0       |
| 4         | 4         |   0       |
| 5         | 5         |   1       |
| 6         | 6         |   1       |
| 7         | 7         |   0       |
| 8         | 8         |   1       |
+-----------+-----------+-----------+

Answer 1

像这样的事情对你有用吗？

 SELECT
     m.Member_ID, m.Last_Name,
     r.Day, r.Month, 
     c.ConfirmID
 FROM 
     table_member m
 INNER JOIN 
     table_reservation r ON r.Member_ID = m.Member_ID
 INNER JOIN
     Confirm c ON c.resvationID = r.resvationID
 WHERE
     m.Last_Name = 'Steven' AND c.confirmed = 1