SQLite Joining tables on Android -

i want join 2 tables in same database. join makes work.

example:

table1: date | name |surname  table2: date | brand

and want table:

table3:

date      |name |surname |brand   01/01/13 jhon     null  02/01/13 null   null  bmw

where rows ordered date not joined, means parameters null.but that's not problem.

is possible? how? thank you.

use union all records respective source tables:

create table table3 select date, name, surname, null brand table1 union select date, null, null, brand table2 order date

Three