select K1.name, k2.name, k3.name, from t1 left join t2 k1 on t1.num1 = k1.num left join t2 k2 on t1.num2 = k2.num left join t2 k3 on t1.num3 = k3.num
select b.name as num1,c.name as num2,d.name as num3 from [表1] a join [表2] b on a.num1 = b.num join [表2] c on a.num2 = c.num join [表2] d on a.num3 = d.num
select a.name, b.name, c.name, from t1 left join t2 a on t1.num1 = a.num left join t2 b on t1.num2 = b.num left join t2 c on t1.num3 = c.num
create table t1(num1 int,num2 int,num3 int) insert into t1 values(1 ,2 ,3) insert into t1 values(3 ,2 ,3) create table t2(num int,name varchar(10)) insert into t2 values(1, 'A') insert into t2 values(2, 'B') insert into t2 values(3, 'C') goselect K1.name, k2.name, k3.name from t1 left join t2 k1 on t1.num1 = k1.num left join t2 k2 on t1.num2 = k2.num left join t2 k3 on t1.num3 = k3.numdrop table t1 , t2/* name name name ---------- ---------- ---------- A B C C B C(所影响的行数为 2 行) */
--创建两张表,并插入测试数据 create table tbTest ( intNumber1 int , intNumber2 int , intNumber3 int )insert into tbTest select 1,2,3 union select 3,2,3create table tbTest2 ( intNumber1 int , chrCharter nvarchar(10))insert into tbTest2 select 1,'A' union select 2,'B' union select 3,'C'--新建函数 create function Fun_UpdateTheFieldValues ( @intNumber int ) returns nvarchar(10) as begin declare @chrNumber nvarchar(10) select @chrNumber=chrCharter from tbTest2 where intNumber1=@intNumber return @chrNumber end--查询语句中调用函数 select dbo.Fun_UpdateTheFieldValues(intnumber1), dbo.Fun_UpdateTheFieldValues(intnumber2),dbo.Fun_UpdateTheFieldValues(intnumber3) from tbTest
k2.name,
k3.name,
from t1
left join t2 k1 on t1.num1 = k1.num
left join t2 k2 on t1.num2 = k2.num
left join t2 k3 on t1.num3 = k3.num
select b.name as num1,c.name as num2,d.name as num3
from [表1] a join [表2] b on a.num1 = b.num
join [表2] c on a.num2 = c.num
join [表2] d on a.num3 = d.num
a.name,
b.name,
c.name,
from
t1
left join t2 a on t1.num1 = a.num
left join t2 b on t1.num2 = b.num
left join t2 c on t1.num3 = c.num
insert into t1 values(1 ,2 ,3)
insert into t1 values(3 ,2 ,3)
create table t2(num int,name varchar(10))
insert into t2 values(1, 'A')
insert into t2 values(2, 'B')
insert into t2 values(3, 'C')
goselect K1.name,
k2.name,
k3.name
from t1
left join t2 k1 on t1.num1 = k1.num
left join t2 k2 on t1.num2 = k2.num
left join t2 k3 on t1.num3 = k3.numdrop table t1 , t2/*
name name name
---------- ---------- ----------
A B C
C B C(所影响的行数为 2 行)
*/
--创建两张表,并插入测试数据
create table tbTest
(
intNumber1 int ,
intNumber2 int ,
intNumber3 int )insert into tbTest
select 1,2,3
union
select 3,2,3create table tbTest2
(
intNumber1 int ,
chrCharter nvarchar(10))insert into tbTest2
select 1,'A'
union
select 2,'B'
union
select 3,'C'--新建函数
create function Fun_UpdateTheFieldValues
(
@intNumber int
)
returns nvarchar(10)
as
begin
declare @chrNumber nvarchar(10)
select @chrNumber=chrCharter from tbTest2 where intNumber1=@intNumber
return @chrNumber
end--查询语句中调用函数
select dbo.Fun_UpdateTheFieldValues(intnumber1), dbo.Fun_UpdateTheFieldValues(intnumber2),dbo.Fun_UpdateTheFieldValues(intnumber3) from tbTest