Hi Guys,I'm trying to reference a column more then once (Really bad explanation) but I'm getting an error of "range variable of "itemname" is already declared"My code is as follows: Dim agentIds = From a In myDataContext.agtAgents, o In myDataContext.eveNames, o2 In myDataContext.eveNames, d In myDataContext.crpNPCDivisions
Where a.agentID = o.itemID _
And a.divisionID = d.divisionID _
And a.corporationID = o2.itemID
Select a.agentID, o.itemName, a.divisionID, d.divisionName, a.corporationID, o2.itemNameo2.itemname is where I'm tripping up.Both the agent name AND the corporation name are in the evename table.However I can't figure out how to display the agent name AND the corporation name.I've tried just using o.itemname but it doesn't work.I am guessing that I need to use alias's but I'm a little unfamiliar with them.Can anyone provide any insight?
View Complete Post