Load with 2 where clauses

[Anonymous]

Hi,

Could someone please help me with this syntax i get an error when it executes

LOAD

A,

B'

clicod,

C,

D

SQL SELECT *

FROM PAB

WHERE NOT clicod = 'IN' and WHERE NOT LEFT(clicod,1) = 'B';

[alexandros17]

the second where in unuseful

SQL SELECT *

FROM PAB

WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';

[#3]

SQL SELECT *

FROM PAB

WHERE clicod <> 'IN' and  LEFT(clicod,1) <> 'B';