3
回答
mysql:Every derived table must have its own alias
利用AWS快速构建适用于生产的无服务器应用程序,免费试用12个月>>>   

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+阅
顶部