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;

下面的sql如何修改 select from select gold1000 as gold from vp_user UNION select sumsiprice 45	1000 as inventory_gold from economyvp_user_inventory ui join economyvp_steam_item as si on uiitem_id = siid

原文地址: https://www.cveoy.top/t/topic/fXRm 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录