sql - "subquery returns more than 1 row" error. -
i new web programming , i'm trying make twitter-clone. @ point, have 3 tables: users (id, name) id auto-generated id name of user tweets (id, content, user_id) id auto-generated id content text of tweet user_id id of user made post followers (id, user_id, following_id) id auto-generated id user_id user doing following following_id user being followed so, being new sql well, trying build sql statement return tweets currently-logged in user , of follows. i tried use statement, works sometimes, other times, error says "subquery returns more 1 row". here statement: select * tweets user_id in ((select following_id followers user_id = 1),1) order date desc i put 1 example here, id of logged-in user. i haven't had luck statement; appreciated! thank you. select * tweets user_id in (select following_id followers user_id = 1) or user_id = 1 order date desc