sqlite

[jashimu]

Hi All, I have two tables. I want to avg both number from table A and table B from the same cell.

2 3 4 3 4
Table A

1 2 5 3 1
Table B

I have two tables like above. I want to average from table one cell one and table two cell one then average both number and put into a third table or get the data and use it.
For example,

1.5 2.5 4.5 3 2.5

How do I do this in sql statement .

[Corporal Agarn]

You would need a common key column as some SQL programs do not keep the order of the table.

[jashimu]

djj55 wrote:

You would need a common key column as some SQL programs do not keep the order of the table.

I am not sure what are you saying.but I do have a column that is comon for for both tables.

[loyal ginger]

You may need to explain the terminology here because I have no idea what "cell one" means in your question. If you use the term "field", "record", etc., you can make your question more understandable by others. As for your question, you can make a query on the union of the two tables to find the averages.

[jashimu]

Sory for the confusion. I should tell you that I am really very very beginer about database. I will find out how to do union and query it. thanks.