> select broker_id from tblbrokers where broker_name = 'afdr' select fspro_userid, firstname, lastname from tbl_fspro_members where ownerid = #val(qrybid.broker_id)# and email = 'dsrdave@afdr.org'