LOADING DATA WITH 'WHERE' CONDITION

[Carlaf_93]

Good morning,

i would like to load data from a db with some conditions. I want year>2019 and a field=A

so I'm writing this:

LIB CONNECT TO '.......'; 

LOAD  
YEAR,
DDOCTIPOARTICOLO,
DDONCOSTO;

[tableA]:
SELECT

YEAR,
DDOCTIPOARTICOLO,
DDONCOSTO
FROM AAAA

WHERE YEAR>2019 AND
where DDOCTIPOARTICOLO='A';
STORE [tableA] INTO [lib://QVD/tableA.qvd] (qvd);

But this doesn't work.  Can someone help me?

Thanks.

[Kushal_Chawda · Accepted solution]

There is a typo in your query. You have written where twice. Try below

LIB CONNECT TO '.......'; 

LOAD  
YEAR,
DDOCTIPOARTICOLO,
DDONCOSTO;

[tableA]:
SELECT

YEAR,
DDOCTIPOARTICOLO,
DDONCOSTO
FROM AAAA

WHERE YEAR>2019 AND
where DDOCTIPOARTICOLO='A';
STORE [tableA] INTO [lib://QVD/tableA.qvd] (qvd);