如何优化 SQL 查询语句:计算用户金币和库存价值
SELECT * FROM ( SELECT gold/1000 AS gold FROM vp_user UNION SELECT SUM(si.price)*45/1000 AS inventory_gold FROM economy.vp_user_inventory ui JOIN economy.vp_steam_item as si ON ui.item_id = si.id ) AS result_table;
原文地址: https://www.cveoy.top/t/topic/osjn 著作权归作者所有。请勿转载和采集!