Joining two tables

[jabmod]

I have 2 tables. one with 5 columns and the other with 6

The tables have an accountid column in commom

I would like to join the tables such that the accountids are not duplicated and the new table now has 10 columns.

Thanks for the help.

 

[r937]

new table? you want to create a new table, or just return the results of the join?

have you checked the tutorial for how to write a join?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[r937]

speaking of things not duplicated, please do not post the same question into two different forums

see

http://www.tek-tips.com/viewthread.cfm?qid=978070&page=1

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)