SQLite中的一个Query中的多个Select语句

如：

SELECT ( 
           SELECT ChestGemEffects.Value,Effect.Name
             FROM ChestGemEffects
                  INNER JOIN Effect
                          ON ChestGemEffects.EffectId = Effect.Id
                  INNER JOIN Gems
                          ON ChestGemEffects.GemId = Gems.Id
            WHERE ( Gems.[Key] = 'SG1' )  
       ) 
       AS ChestEffects,( 
           SELECT WeaponGemEffects.Value,Effect.Name
             FROM WeaponGemEffects
                  INNER JOIN Effect
                          ON WeaponGemEffects.EffectId = Effect.Id
                  INNER JOIN Gems
                          ON WeaponGemEffects.GemId = Gems.Id
            WHERE ( Gems.[Key] = 'SG1' )  
       ) 
       AS WeaponEffects,( 
           SELECT OthersGemEffects.Value,Effect.Name
             FROM OthersGemEffects
                  INNER JOIN Effect
                          ON OthersGemEffects.EffectId = Effect.Id
                  INNER JOIN Gems
                          ON OthersGemEffects.GemId = Gems.Id
            WHERE ( Gems.[Key] = 'SG1' )  
       ) 
       AS OthersEffects;

它给了我错误：

‘执行查询时出错：只有一个结果允许作为表达式一部分的SELECT’

我的表达式有问题还是SQLite不支持？

谢谢

SELECT * FROM (SELECT ...),(SELECT ...)

但是,这将是一个cross join,这不是你想要的.

要只附加多个表(具有相同的列数),请使用UNION ALL：

SELECT ChestGemEffects.Value,Effect.Name
  FROM ...
  ...
UNION ALL
SELECT WeaponGemEffects.Value,Effect.Name
  FROM ...
  ...

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!