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