Querying from multiple tables in Android SQLite?

You can create view based on your tables, the query of your view is union of your tables.

You can create view based on your tables, the query of your view is union of your tables. Create view test as select * from table1 union select * from table2 now you can filter data as you want for more info check union & view w3schools.com/sql/sql_union.asp w3schools.com/sql/sql_view.asp.

In the end, I decided to forgo having many subsubtables, and instead adding another column like Tim and Samuel suggested. It will probably be more efficient as well then chaining SELECTs with UNION.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.