Somewhat Painful Join Code

Hello.

Newbie on SQL and suffering through this.

I have two tables created as such:

drop table table1;
go
drop table table2;
go
create table table1(
name varchar(10),
code1 integer,
code2 integer,
code3 integer,
code4 integer,
code5 integer
);
go
create table table2(
code integer,
descript varchar(50)
);
go
INSERT INTO table1 VALUES ('mary',1,7,8,9,13)
INSERT INTO table1 VALUES ('mary',1,7,8,9,13)
INSERT INTO table1 VALUES ('mary',1,7,7,7,13)
INSERT INTO table1 VALUES ('mary',1,7,8,9,13)
INSERT INTO table1 VALUES ('joe',1,7,8,9,3)
INSERT INTO table1 VALUES ('bob',1,7,8,9,3)
INSERT INTO table1 VALUES ('larry',22,17,18,19,113)
INSERT INTO table1 VALUES ('mary',1,3,2,9,13)
INSERT INTO table2 VALUES (1,'code1')
INSERT INTO table2 VALUES (3,'code3')
INSERT INTO table2 VALUES (7,'code7')
go



Table1 will have duplicate name entries and code1 - code5 could
contain any range of numeric codes, including dups in the same row or
other rows.

Table2 sorted and indexed unique by code contains only the codes I'm
interested in reporting.

I need to produce report:

name code count (of names that contain at least 1 code in Table2)

I'll go back to suffering through it now, but I thought I'd post since
I'm not exactly sure where to begin.

Thank you for any help or information!

My above email is no longer active, so please post to the list so that
everyone can benefit and your contribution lives on.