Hi all,

I run sql statement via flamerobin, the statment is like this :

SELECT * FROM M_INT_FRM a
where a.ID_TRS_TYP = 100

It will returns :

ID ID_DIV_LC SCT_INI ID_TRS_TYP FRM_INI
========================================
4  8         MP      100        PO
5  9         MN      100        PO
6  0         MS      100        PO


but if I change sql statement to this

SELECT * FROM M_INT_FRM a
where a.ID_TRS_TYP = 100
and a.id_div_lc = 0

no sql result returns.

You can download the database at http://www.mediafire.com/?bx8k29kt7x2ucks

Strange, could it be a bug?

Thanks and regards,
Sugiarto

Reply via email to