如何从两个表中获取数据 [英] How to get data from two tables

问题描述

亲爱的，



我想以这种方式获取数据。我有2张桌子。



表1：

Dear all,

I want to get data in this way. I have 2 tables.

Table1:

INST_CODE          ADDRESS          PHONE        EMAIL

DPS101               DELHI        011965321    DPSDEL@IN
GLA02                NOIDA        12036450      swa@in

TABLE2

TABLE2

ID       INST_CODE           CITY           OPENING        POSITION          INST_ID

1         DPS101             DELHI            2             SALES             1
2         DPS101             DELHI            5            TECHNICAL          1
3         GLA02              NOIDA            1             SALES             2

结果

RESULT LIKE

INST_CODE            ADDRESS            PHONE           EMAIL        TYPE

DPS101                DELHI            012063548       DPSDEL@IN     SALES
DPS101                DELHI            012063548       DPSDEL@IN    TECHNICAL
GLA02                 NOIDA            012365466       swa@in       SALES

推荐答案

从基础开始： SQL JOINS [ ^ ]。连接类型很少。这里给出了不同之处： SQL连接的可视化表示 [ ^ ]



INNER JOIN示例：

Start with basics: SQL JOINS[^]. There is few types of joins. The difference is presented here: Visual Representation of SQL Joins[^]

INNER JOIN sample:

SELECT t1.Field1, t1.Field2, t2.Field1, t2.Field2
FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.Key = t2.ForeignKey

尝试从表2加入表1.

Try joining from table 2 to table 1.

Select T2.INST_CODE, T1.ADDRESS, T1.PHONE, T1.EMAIL, T2.POSITION
 
 From TABLE2 as T2
 InnerJoin TABLE1 as T1
 ON T2.INST_CODE = T1.INST_CODE

无论如何都是这样的！

Something like that anyway!

这很简单亲爱的。只需使用Inner Join

It is very Simple dear. Just use Inner Join

SELECT
  T1.INST_CODE,
  T1.ADDRESS,
  T1.PHONE,
  T1.EMAIL,
  T2.POSITION AS [TYPE]
FROM
  table1 T1 WITH(NOLOCK)
  JOIN table2 T2 WITH(NOLOCK) ON T1.INST_CODE=T2.INST_CODE<

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