Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
the second where in unuseful
SQL SELECT *
FROM PAB
WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';
SQL SELECT *
FROM PAB
WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';