#1242-子查询返回的行数超过1 [英] #1242 - Subquery returns more than 1 row

问题描述

SELECT answer FROM answer WHERE q_id=(SELECT q_id FROM question WHERE dept="Maths")

推荐答案

尝试将其更改为以下内容.

Try by changing it to as below.

SELECT answer FROM answer WHERE q_id in (SELECT q_id FROM question WHERE dept="Maths")

这篇关于#1242-子查询返回的行数超过1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！