Having problems importing Data from 2 tables into 1. Please help.

Hi
I am new to SQL and am having problems importing data from two tables to one.
I have 3 tables : Franchise, Club and Reference.
Franchise has FranchiseID as Primary key and FranchiseNumber as unique.
Club has ClubID as Primary key.
Reference has a combination of ClubID and FranchiseNumber as primary key.
I am not able to insert data into table Reference from Franchise and Club.
Any help or suggestions would be highly appreciated. Thanks in advance.

Try the link below for INSERT INTO with Column list which gives you control of the order of INSERT. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_5cl0.asp|||Thnx very much !!