lundi 27 avril 2015

Android SQLite join two tables that have not related columns but are connected to the same table

I have 3 tables and I want to join 1 and 3 so I have access to all of table1 columns and the first and last name columns of table3. Their only connection is table two. This is how the tables look. Is it possible to join tables 1 and 3?

TABLE1
    - table2_id

TABLE2
   - _id
   - table3_id

TABLE3
    - _id
    - first_name
    - last_name

Aucun commentaire:

Enregistrer un commentaire