Hi,

Following on from the previous post. I want to take the list of columns that match, so change the outer join to an inner join. Then insert a record into A that exist in B.

The reason to use the first query is the colunms in A dont match B and I dont want to have to type out each column manually.

Any Ideas??