I made a database (ADO) using Visual Data Manager (VB6) with 3 tables: clients (with address,city,etc.)and phones(with model, phonenumber, hexa, etc.) and devices (with phonenumber,version,etc). The field codeclient is the index (primary key), for tables clients and phones. And the field phonenumber is the index (primary key), for tables phones and devices. How can I to establish a relation between the 3 tables using SQL, to search for example all the phonenumber of a client, and all versions of a phonenumber?
Thank you, for any help.
Thank you, for any help.
