What's the difference between these two SQL queries, one works, the other doesn't

Vote count:

0

Guys I wanted to check out what's the difference between these two SQL queries.

Number 1 works, and number 2 doesn't. I wanna ask you guys why 2 doesn't work.

1) SELECT  ANIO,  CIF, COSTO_UNITARIO, ID_PRODUCTO, ID_SUCURSAL, STOCK_FINAL,  ZETA, codigo_interno FROM STOCKS WHERE (ID_SUCURSAL = @SUCURSAL) AND (ID_PRODUCTO = @PRODUCTO)  AND (ANIO = @ANIO) AND 
(STOCK_FINAL > 0)

2)SELECT ABR_FIN, ABR_INI, AGO_FIN, AGO_INI, ANIO, CAMBIO, CIF, COSTO_UNITARIO, DEC_FIN, DEC_INI, ENE_FIN, ENE_INI, FEB_FIN, FEB_INI, FECHA, ID_CAMBIODEPOSITO, ID_PRODUCTO, ID_SUCURSAL, JUL_FIN, JUL_INI, JUN_FIN, JUN_INI, MAR_FIN, MAR_INI, MAY_FIN, MAY_INI, NOV_FIN, NOV_INI, OCT_FIN, OCT_INI, 
SEP_FIN, SEP_INI, STOCK_FINAL, STOCK_INICIAL, ZETA, codigo_interno FROM STOCKS WHERE (ID_PRODUCTO = @PRODUCTO) AND (ID_SUCURSAL = @SUCURSAL) AND (ANIO = @ANIO) AND (STOCK_FINAL > 0)

Thanks a lot !!!!

asked 31 secs ago

user2472896

1

What's the difference between these two SQL queries, one works, the other doesn't