Enjoy...
create table Human(id int IDENTITY,SomeField varchar(50))
create table Club(id int IDENTITY,SomeField varchar(50))
create table HumanClub(id int IDENTITY,HumanId int, ClubId INT)
DECLARE @HumarId INT, @ClubId INT
INSERT INTO Human values('Some Human')
SET @HumarId = SCOPE_IDENTITY()
INSERT INTO Club values('Some Club')
SET @ClubId = SCOPE_IDENTITY()
INSERT INTO HumanClub values(@HumarId,@HumarId)
SELECT * FROM HumanClub