>yes its logical , maybe i gave a bad explation. the thing is, an account can be like broker and client or all of them. so if i do select blablab from tb_account where tr_intclient = .t. and tr_intbroker = .t., i will only those one who is client and broker. the thing i want to do is i want to get all the client, all the broker and the who are the two . do you understand what i want ? sorry but today i dont know how to explain myself :)

If you change AND to OR you get all of them.