Retrieve multiple rows from table2 based on single row from table1 in SQL Server
The query you need is:

SELECT 
    camp.Campiagn_Id, 
    camp.Campiagn_Name, 
    camp_list.Campign_Id, 
    camp_list.EmalList 
FROM 
    [table1] AS camp 
    LEFT JOIN [table2] AS camp_list ON (camp.Campiagn_Id = camp_list.Campiagn_Id);


This will show all campaigns with all emails lists for each campaign. It will show also campaign with no emails list.

You can add or remove fields in the select as you need.