我有一个复杂的select查询,它返回一个结果:
1_id 2_id 3_id 4_id CultureId
value1 value2 value3 a 1
value1 value2 value3 b 2
我需要以以下格式获得结果:
1_id 2_id 3_id 4_id_1 4_id_2
value1 value2 value3 a b
我能想到这种方法,但也许有更好的方式实现?
SELECT 1_id, 2_id, 3_id, (SELECT 4_id from table where 1_id = value1 and CultureId = 1) as 4_id_1,
(SELECT 4_id from table where 1_id = value1 and CultureId = 2) as 4_id_2
from table where 1_id = value1
问题在于我的实际内部SELECT查询(“SELECT 1_id,2_id,3_id,4_id CultureId from table where 1_id = value1”)被我在解决方案中使用了三次,它是一个复杂的查询,包含几个连接,使得这个解决方案变得非常庞大。
是否有简化它的方法?