jpa查询问题

Question

teachCar表
+----+------------------+
| id | customer_base_id |
+----+------------------+
| 1 | 1 |

+----+------------------+

customerBase表

+----+-----------+
| id | name |
+----+-----------+
| 1 | 训练场 |
| 2 | 金洲 |
| 3 | 白坊 |
+----+-----------+

通过这两个表，如何通过jpql语句查询不存在teachCar表内的customerBase对象，请高手帮下小弟

小弟写的这句：SELECT customerBase FROM CustomerBase customerBase WHERE customerBase = (SELECT teachCar FROM TeachCar teachCar WHERE teachCar.customerBase)有问题，请指点

Answer 1

SELECT customerBase FROM CustomerBase customerBase WHERE customerBase.id in (SELECT teachCar .customerBase FROM TeachCar teachCar )