如何合并log_iOS_crash和log_android_crash数据进行查询

{/'title/':/'如何合并log_iOS_crash和log_android_crash数据进行查询/',/'description/':/'本文介绍了如何新增数据表log_android_crash，并将log_android_crash与log_iOS_crash进行合并查询，以解决log_iOS_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier不满足时的问题。/',/'keywords/':/'SQL, 数据表合并, 联合查询, LEFT JOIN, log_iOS_crash, log_android_crash/',/'content/':/'要新增数据表log_android_crash，可以使用以下SQL语句：//n//nCREATE TABLE log_android_crash (//n crash_uuid VARCHAR(255),//n -- 其他列...//n);//n//n然后，修改原有的查询语句，将log_iOS_crash替换为log_iOS_crash和log_android_crash的联合查询，并使用LEFT JOIN来处理不满足log_iOS_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier的情况。修改后的查询语句如下：//n//nSELECT //n CASE WHEN log_iOS_crash.crash_uuid IS NOT NULL THEN log_iOS_crash.crash_uuid ELSE log_android_crash.crash_uuid END AS crash_uuid,//n COUNT(CASE WHEN log_iOS_crash.crash_uuid IS NOT NULL THEN log_iOS_crash.crash_uuid ELSE log_android_crash.crash_uuid END) AS count,//n log_iMonkey_Wechat_overview.PlatformType//nFROM //n (log_iOS_crash//n LEFT JOIN log_iMonkey_Wechat_overview ON log_iOS_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier)//n UNION ALL//n (log_android_crash//n LEFT JOIN log_iMonkey_Wechat_overview ON log_android_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier)//nWHERE //n (log_iOS_crash.crash_uuid IS NOT NULL OR log_android_crash.crash_uuid IS NOT NULL)//n AND (log_iOS_crash.crash_uuid GLOBAL IN (//n SELECT DISTINCT CrashIdentifier//n FROM log_iMonkey_Wechat_overview//n WHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND//n Ds >= toDateTime(#wechat_crash_level_time.start#)//n AND Ds <= toDateTime(#wechat_crash_level_time.end#)//n GROUP BY PlatformType, CrashIdentifier//n ) OR log_android_crash.crash_uuid IS NOT NULL)//nGROUP BY //n crash_uuid, log_iMonkey_Wechat_overview.PlatformType/