transpose - sqlite extract two row from two tables to create a new table -

transpose - sqlite extract two row from two tables to create a new table -

i have sqlite db 2 table

table1

------------------------------ time | elevationa| elevationb| -----|-----------|-----------| t1 | ea1 | eb1  | t2 | ea2 | eb2 |

table2

------------------------------ time | temperat a| temperat b| -----|-----------|-----------| t1 | ta1 | tb1  | t2 | ta2 | tb2 |

i searching "magic" command create table of parameter @ given time, e.g like:

select where time=t1 table1 elev ,table2 as temp

and result in

table3

------------ elev | temp | -----|----- | ea1 | ta1 | eb1 | tb1 |

of course of study bash script prefer create view in sqlite more straightforwards , avoid duplicate data. thought welcome

you can use:

create table table3(elev,temp); insert table3(elev,temp) values((select time table1 time = t1),select time table2 time =t2));

these 2 select clauses must homecoming same number of records.

sqlite transpose multiple-tables