3
回答
mysql:Every derived table must have its own alias
科大讯飞通用文字识别100000次/天免费使用。立即申请   

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