SELECT
B.[画面用Pattern] as 1,
C.[画面用Pattern] as 2,
D.[画面用Pattern] as 3,
E.[画面用Pattern] as 4,
F.[画面用Pattern] as 5,
G.[画面用Pattern] as 6,
H.[画面用Pattern] as 7,
I.[画面用Pattern] as 8,
J.[画面用Pattern] as 9,
K.[画面用Pattern] as 10
FROM [dbo].[calendar] A
LEFT JOIN [dbo].[tariff] B ON A.[bango]=B.[bango] AND A.[Pattern_1]= B.[Pattern]
LEFT JOIN [dbo].[tariff] C ON A.[bango]=C.[bango] AND A.[Pattern_2]= C.[Pattern]
LEFT JOIN [dbo].[tariff] D ON A.[bango]=D.[bango] AND A.[Pattern_3]= D.[Pattern]
LEFT JOIN [dbo].[tariff] E ON A.[bango]=E.[bango] AND A.[Pattern_4]= E.[Pattern]
LEFT JOIN [dbo].[tariff] F ON A.[bango]=F.[bango] AND A.[Pattern_5]= F.[Pattern]
LEFT JOIN [dbo].[tariff] G ON A.[bango]=G.[bango] AND A.[Pattern_6]= G.[Pattern]
LEFT JOIN [dbo].[tariff] H ON A.[bango]=H.[bango] AND A.[Pattern_7]= H.[Pattern]
LEFT JOIN [dbo].[tariff] I ON A.[bango]=I.[bango] AND A.[Pattern_8]= I.[Pattern]
LEFT JOIN [dbo].[tariff] J ON A.[bango]=J.[bango] AND A.[Pattern_9]= J.[Pattern]
LEFT JOIN [dbo].[tariff] K ON A.[bango]=K.[bango] AND A.[Pattern_10]= K.[Pattern]就[dbo].[calendar] 和[dbo].[tariff]两个表
还能用方法来实现这样的sql?
B.[画面用Pattern] as 1,
C.[画面用Pattern] as 2,
D.[画面用Pattern] as 3,
E.[画面用Pattern] as 4,
F.[画面用Pattern] as 5,
G.[画面用Pattern] as 6,
H.[画面用Pattern] as 7,
I.[画面用Pattern] as 8,
J.[画面用Pattern] as 9,
K.[画面用Pattern] as 10
FROM [dbo].[calendar] A
LEFT JOIN [dbo].[tariff] B ON A.[bango]=B.[bango] AND A.[Pattern_1]= B.[Pattern]
LEFT JOIN [dbo].[tariff] C ON A.[bango]=C.[bango] AND A.[Pattern_2]= C.[Pattern]
LEFT JOIN [dbo].[tariff] D ON A.[bango]=D.[bango] AND A.[Pattern_3]= D.[Pattern]
LEFT JOIN [dbo].[tariff] E ON A.[bango]=E.[bango] AND A.[Pattern_4]= E.[Pattern]
LEFT JOIN [dbo].[tariff] F ON A.[bango]=F.[bango] AND A.[Pattern_5]= F.[Pattern]
LEFT JOIN [dbo].[tariff] G ON A.[bango]=G.[bango] AND A.[Pattern_6]= G.[Pattern]
LEFT JOIN [dbo].[tariff] H ON A.[bango]=H.[bango] AND A.[Pattern_7]= H.[Pattern]
LEFT JOIN [dbo].[tariff] I ON A.[bango]=I.[bango] AND A.[Pattern_8]= I.[Pattern]
LEFT JOIN [dbo].[tariff] J ON A.[bango]=J.[bango] AND A.[Pattern_9]= J.[Pattern]
LEFT JOIN [dbo].[tariff] K ON A.[bango]=K.[bango] AND A.[Pattern_10]= K.[Pattern]就[dbo].[calendar] 和[dbo].[tariff]两个表
还能用方法来实现这样的sql?
看着就是怪怪的