我如何加入两个表？ [英] How Do I Join Two Tables ?

问题描述

其实我想加入两张桌子，例如

table-1

Movieid

Moviecode



table-2

id

Movieid

Moviename



所以我想绑定这两个表来获得结果，如获取moviename并在括号中获取其电影代码..



例如Abc（212）

解决方案

检查此查询

  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();

这篇关于我如何加入两个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！