Çó¼òµ¥sql - MS-SQL Server / »ù´¡Àà

table1£º
id name sub

1 q w

2 r t

3 y n


table2£º
id title_id text

1 3 u

2 2 i

3 1 p

4 2 b

5 1 m


ÇósqlÓï¾ä ²éѯ³ö title_id ÏàͬµÄÏî ²¢ÇÒ²é³öÔÚtable1ÖÐ id = title_id ÁеÄname
½á¹û£º
  2 2 i r

  2 2 b r

---

2 2 b r µÚÒ»¸ö2ÊDz»ÊǸÃΪ4°¡?

---

Äã¸øµÄÊý¾ÝºÍ½á¹ûòËƲ»¶Ô.

---

SQL code:
select a.id,b.title_id,b.text,a.sub from table1 a join table2 b on a.id=b.title_id

---

title_id table1ÖÐid text name

2 2 b r

2 2 i r

---

½á¹û²»¶Ô°É

---

SQL code:
--½á¹ûºÃÏñÓгöÈë
if not object_id('table1') is null
drop table table1
Go
Create table table1([id] int,[name] nvarchar(1),[sub] nvarchar(1))
Insert table1
select 1,N'q',N'w' union all
select 2,N'r',N't' union all
select 3,N'y',N'n'
Go
if not object_id('table2') is null
drop table table2
Go
Create table table2([id] int,[title_id] int,[t