topic Re: I load data from SQL but I want to load some data and I have Problem following in App Development

I load data from SQL but I want to load some data and I have Problem following

Anonymous — Fri, 21 Sep 2018 03:17:46 GMT

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);

Anonymous — Fri, 21 Sep 2018 03:20:53 GMT

Problem

alexandrakfcosta — Fri, 21 Sep 2018 15:45:25 GMT

Hi, Surawut.

I think the problem is with the SQL syntax in the WHERE clause.

The way to use multiple WHERE clauses is using the connector AND (and removing the commas at the end of each line), like this:

WHERE "S_ACCOUNT" = ('68001000','52001500','68119000','68002000')

AND "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP')

AND "S_REF_KEY_1" <> ('OIL')

AND "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);

I hope I could help.

Best,

Alexandra Costa

Anonymous — Mon, 24 Sep 2018 11:25:26 GMT

thank you