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