3
回答
mysql:Every derived table must have its own alias
终于搞明白,存储TCO原来是这样算的>>>   

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
发帖于5年前 3回/3K+阅
顶部