检查此查询

  SELECT  table2.Moviename + ' （' + table1.Moviecode + ' ）'  as  movieName  FROM  table1 
 INNER   JOIN  table2  ON  table1.Movieid = table2.Movieid 

  var  query =（ from    table1 inner 加入 b   table2 on a.movi​​eid = b.movi​​eid 
 select  NEW {b.movi​​ename +   （ + a.movi​​ecode +  ）}）。ToList（）; 

Actually i want to join two tables e.g.
table-1
Movieid
Moviecode

table-2
id
Movieid
Moviename

so i want to bind these two table to get result like,get moviename and in bracket its movie code..

e.g. Abc(212)

check this query

SELECT table2.Moviename+'('+ table1.Moviecode+')' as movieName FROM table1
INNER JOIN table2 ON table1.Movieid=table2.Movieid

var query =(from a in table1 inner join b in table2 on a.movieid=b.movieid
select NEW {b.moviename+" ( "+a.moviecode+" ) " }).ToList();