执行以下查询时出错

Question

i am trying to run this query. but it shows either 1 row or give error query result having more than 1 row.

select * from abc where id=(select nameid from xyz where name like '%abc%')

help me. i am executing a query where i get name, father name and schoolid from table abc. now i want school name from table2 by running another query in it but in all time it shows 1

Answer 1

Use the IN to fetch the more than 1 row:

select * from abc where id IN (select nameid from xyz where name like '%abc%');

EDIT:

select a.*, x.school_name from abc a left join xyz x on a.id = x.nameid where name like '%abc%';