RIA Services Linq: join with multiple conditions
===

I have to translate the following query into Linq on my RIA project


    Select table1.EntryId,table2.Event, 
    (select table3.value from table3 
    inner join table4 on (table3.schema=table4.schema and table3.value=table4.value)
    inner join table5 on (table5.eventId=table3.eventId and table5.eventId=table4.eventId))
    From table1 inner join table2 on table1.EntryId=table2.EntryId

This is my CustomClass:

    public class CustomTable
    {
        [Key]
        public string EntryId { get; set; }
        public string Event { get; set; }
        public string status { get; set; }
       
    }

This is what I reached so far:

                 return (from i in this.ObjectContext.table1
                join p in this.ObjectContext.table2 on i.Entry_ID equals p.Entry_ID
               
    
        select new CustomTable
            {
                EntryId = i.Entry_ID,
                Event=p.EventId,
                status = (
                            from e in this.ObjectContext.table3
                            join f in this.ObjectContext.table4 on new
                            { table3.schema,table3.value } equals new { table4.schema, table4.value}
                            join table5 on ...
                            select new { table3.value.value }
                                    
                          )
            });

My struggle now is with two issues:

 - 1- What is the right way to perform these multiple join conditions
 - 2- Even when I tried to reduce the query, I got the following error
       over the last "select":


> Cannot implicitly convert type
> 'System.Linq.IQueryable<AscPassdown.Web.CustomTable>' to 'string'

I really appreciate your help
	