Trying to link non-identical tables

[kinchin]

I have two tables, with some similar columns, i would like to link these tables together to produce one table with all the columns from one table and some of the columns from the other.

I understand that merge tables will only work with identical tables.

also, I don't really want all the rows from one of the tables in the final table.

Can anyone help?

 

[r937]

use a SELECT with a JOIN and a WHERE clause

or maybe i don't understand the problem?


rudy