MySql 不同的问题 : Error Code: 1242 Subquery returns more than 1 row

Question

我想选择不同的 apps_user.imeino

我当前的 SQL 查询:

SELECT app.name,app.emailid,app.mobileno,app.imeino,img.id,img.approve_status,img.path 
FROM apps_user  app, apps_userimage img 
WHERE ((SELECT DISTINCT apps_user.imeino FROM apps_user) =img.imeino );

MySql 明显问题:错误代码:

1242 Subquery returns more than 1 row

Answer 1

你需要加入

SELECT app.name,app.emailid,app.mobileno,app.imeino,img.id,img.approve_status,img.path 
FROM apps_user app
join apps_userimage img on app.imeino = img.imeino