Hi,
I wanna make [LA,LI,LS,LU,LX,LY] = LUFT as well as [XY,MN,ST] = BASE
Please see below for more understanding
That's my query:
SELECT
[ABC] = 'LUFT',
ROUND(SUM([GWU VS]),1) AS [GWU LUFT],
[ABC] = 'BASE',
ROUND(SUM([GWU VS]),1) AS [GWU BASE]
FROM tbl1
WHERE [ABC]='LA' OR [ABC]='LI' OR [ABC]='LS'
OR [ABC]='LU' OR [ABC]='LX' OR [ABC]='LY'
AND
[ABC]='XY' OR [ABC]='MN' OR [ABC]='ST'
My Table:
ABC GWU VS
LA 100
LI 80
LS 50
LU 200
LX 220
LY 150
XY 450
MN 600
ST 85
But I'm getting the wrong results
What i really wanna archieve / expected result:
ABC GWU VS
LUFT 800
BASE 1135
Is it accomplishable?