我的答案绝对是兼容性最好的!建议你好好琢磨琢磨
不是所有的数据库都支持派生表的!SELECT [bank].[name],MAX([user].[money]) + SUM([bank].[money])
FROM [user] LEFT JOIN [bank] ON [user].[name] = [bank].[name]
GROUP BY [bank].[name]
ORDER BY MAX([user].[money]) + SUM([bank].[money]) DESC
SELECT [bank].[name],MAX([user].[money]) + SUM([bank].[money])
FROM [user],[bank]
WHERE [user].[name] = [bank].[name]
GROUP BY [bank].[name]
ORDER BY MAX([user].[money]) + SUM([bank].[money]) DESC
不是所有的数据库都支持派生表的!SELECT [bank].[name],MAX([user].[money]) + SUM([bank].[money])
FROM [user] LEFT JOIN [bank] ON [user].[name] = [bank].[name]
GROUP BY [bank].[name]
ORDER BY MAX([user].[money]) + SUM([bank].[money]) DESC
SELECT [bank].[name],MAX([user].[money]) + SUM([bank].[money])
FROM [user],[bank]
WHERE [user].[name] = [bank].[name]
GROUP BY [bank].[name]
ORDER BY MAX([user].[money]) + SUM([bank].[money]) DESC
原来之前我忘记了加MAX,可是为什么要加MAX才生效的啊?
faint~~~
SELECT [bank].[name],MAX([user].[money]) + SUM([bank].[money])
FROM [user],[bank]
WHERE [user].[name] = [bank].[name]
GROUP BY [bank].[name]
ORDER BY MAX([user].[money]) + SUM([bank].[money]) DESC SELECT bank.name,MAX(user.money) + SUM(bank.money)
FROM user,bank
WHERE user.name = (+) bank.name
GROUP BY bank.name
ORDER BY MAX(user.money) + SUM(bank.money) DESC
用 MAX() 或 MIN() 都是一样的!因为那时 user.money 都是一样的!
你好好琢磨琢磨!
先执行一下这个,你就明白了!SELECT [bank].[name],[bank].[money],[user].[money],[user].[name]
FROM [user],[bank]
WHERE [user].[name] = [bank].[name]