Integrated main query joining values from two tables

LINQ implemented