这种关联在术语上怎么称呼? 双关联吗? 请教.
CREATE TABLE T1(
F11 char(10) NOT NULL,
F12 char(10) NULL,
F13 char(10) NULL,
F14 char(10) NULL,
CONSTRAINT PK1 PRIMARY KEY NONCLUSTERED (F11)
)
go
CREATE TABLE T2(
F21 char(10) NOT NULL,
F22 char(10) NULL,
CONSTRAINT PK2 PRIMARY KEY NONCLUSTERED (F21)
)
go
ALTER TABLE T1 ADD CONSTRAINT RefT22
FOREIGN KEY (F13)
REFERENCES T2(F21)
go
ALTER TABLE T1 ADD CONSTRAINT RefT23
FOREIGN KEY (F14)
REFERENCES T2(F21)
go
Insert Into T2(F21, F22) Values('F211', '张三')
Insert Into T2(F21, F22) Values('F212', '李四')
Insert Into T2(F21, F22) Values('F213', '赵五')
Insert Into T2(F21, F22) Values('F214', '钱六')
Insert Into T1(F11, F12, F13, F14) Values('F111', 'F121', 'F211', 'F212')
Insert Into T1(F11, F12, F13, F14) Values('F112', 'F122', 'F213', 'F214')
--------想要的结果如下-------
F111 F121 张三 李四
F112 F122 赵五 钱六
----------------------------