3
回答
mysql:Every derived table must have its own alias
注册华为云得mate10,2.9折抢先购!>>>   

java中直接写如下sql:

SELECT ID,NAME,AGE,ID IN (SELECT ROLEID FROM SYSTEM_USER_ROLE WHERE USERID = @userId) AS T FROM SYSTEM_ROLE WHERE ORGANIZATIONID = @organizationId"); 

出错信息:Every derived table must have its own alias   数据库:mysql5.5

该如何修改?

举报
haorizi
发帖于6年前 3回/3K+阅
顶部