Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Header 1 | Header 2 | Header 3 |
---|---|---|
Price | Ref.1 | Ref.2 |
500 | Oil | - |
900 | WAG | 2 |
700 | WAG | - |
800 | WAG | 3 |
799 | WAG | - |
where ref.1 not Oil and where ref.1 WAG not 2,3
EX.
Header 1 | Header 2 | Header 3 |
---|---|---|
Price | Ref.1 | Ref.2 |
700 | WAG | - |
900 | - | - |
I load data from SQL but I want to load some data and I have Problem following
FROM "MIS_DataLake_UAT".dbo."SAP_COST"
where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),
where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),
where "S_REF_KEY_1" <> ('OIL'),
where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);
Problem
incorect syntax near ','.