Not very experience at this yet, so maybe this is a bad query idea from start up..
I have this fields in 2 tables
Table A: myid, name, associateID1, associateID2
Table B: assocateID, name, tel, fax
And I want to make a query, by supplying myid, to find TableA.name, and TableB.name for both...