>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 :)
Ten use OR:
SELECT ....
FROM ....
WHERE tr_intclient OR tr_intbroker
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.