>>i have a table named tb_account. inside this table i have all information about the account. i have four type of account. it cant be client,broker,carrier and propest. (its 4 different field). so an account can be one of them , or two of them etc... so if i want a select to retrieve all the client, broker account ??? how can i do that ?
>
>Sounds to me like normalisation is needed, if you have redundant repeater groups like this. I'd say there should be an account_type look-up table, with the 4 acc. types, and a link (m-to-m) table between them, giving client# and acc_type#.
>
>Then each client rec may have 1 or more of these link recs, depending on how many accs he has.

Terry,

Are you sure it is a "normalisation"? Or you're talking with British accent today?