need help

[mag]

Hi there,

I'm trying to create simple database using openoffice. I have to list of sxc files. I need to compare both files and come out with the result in new file.

For example table1 has : id, name, age, height.
table2 has: age, height, weight.

table3 has to contain id,name, age, height, and weight which will match to table1 and 2.

What i mean is age and height from table1 and 2 will be compared and height for the match will come out in new table with id, name, age, heigh, and weight.

anyone can help....

[acolvin]

do the ids match?
do the names match?

you just need a query with a join between the tables

[mag]

I have create 3 tables and all are .dbf files under a data source called source1. 2 tables contains data and one is empty. Now i need to compare to table and insert result into empty table.

I have no idea how and where to write the queries. Any one can give some examples. Pls...