<div>
If I understand the issue correctly, then one of Zberteoc's <b>Join</b> statements needs to reference the <i>s.AwayID</i> rather than both pointing to <i>s.HomeID</i>.
</div>


If I understand the issue correctly, then one of Zberteoc's Join statements needs to reference the s.AwayID rather than both pointing to s.HomeID.

<div>
One correction the last line should be:<br />
<br />
AwayTeam &nbsp; &nbsp; &nbsp;=t2.TeamName
</div>


One correction the last line should be:

AwayTeam      =t2.TeamName

<div>
<div class="content wysiwyg-content">
I am having trouble with a LINQ query to return the name of the Home and Away team from the same table. &nbsp;I have &nbsp;schedule table with awayid and homeid. &nbsp;In sql server it's easy to reference the teams table as teams and teams1 and get my data in same record. &nbsp;I cannot figure out the LINQ code to produce same results. &nbsp;<br />
<br />
This brings in home team name. &nbsp;How would I change it to also get away team from teams table.<br />
<br />
&nbsp;Dim curScores = From s In db.Schedules Join hteams In db.Teams On s.HomeID Equals hteams.Teamid<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Where s.Week = 3 And s.Season = &quot;2014&quot; Select Teamid = s.HomeID, HomeTeam = hteams.TeamName
</div>
</div>


I am having trouble with a LINQ query to return the name of the Home and Away team from the same table.  I have  schedule table with awayid and homeid.  In sql server it's easy to reference the teams table as teams and teams1 and get my data in same record.  I cannot figure out the LINQ code to produce same results.  

This brings in home team name.  How would I change it to also get away team from teams table.

 Dim curScores = From s In db.Schedules Join hteams In db.Teams On s.HomeID Equals hteams.Teamid
                Where s.Week = 3 And s.Season = "2014" Select Teamid = s.HomeID, HomeTeam = hteams.TeamName

LINQ Query Joining same table twice

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.