Join 3 datatables in c#
<p>I have the following 3 data-tables:</p>

<pre><code>    Table1 
    --------------------------------
    ScheduleID | Name  | Details
    -----------------------------
    1             S1     schedule details 
    2             S2     schedule details
    3             S3     schedule details
    4             S4     schedule details


    Table2
    ------------------------------
    ScheduleGroupID  | ScheduleID 
    ------------------------------
    1                      1      
    1                      2    
    1                      3     
    2                      4     

    Table3
    -----------------------------------------------
    ScheduleGroupID   | Description  | ScheduleCount
    ------------------------------------------------
    1                    Urgent             3
    2                    Non-urgent         1


    Expected Result
    ---------------------------------------------------------------
    ScheduleID | Name | Details | ScheduleGroupID |   Description
    -------------------------------------------------------------
    1             S1       5             1         Urgent(row from table3) 
    2             S2       5             1         Urgent(row from table3) 
    3             S3       5             1         Urgent(row from table3) 
    4             S4       5             2         Non-urgent(from table3) 
</code></pre>

<p>So i have three datatables and would like to merge them into one table in order to produce the expected result shown above. How can this be done within c#? I assume i would have to use LINQ but don't have much experience with it.</p>