有两个表 GA_GJDQ GA_WJRY
在表GA_GJDQ中有GJDQ_ID,GJDQ_BM(国家编码),GJDQ_GJDQ(国家名称) 字段
在表GA_WJRY中有WJRY_ID,WJRY_NAME(人员姓名),WJRY_SEX(性别),WJRY_GJDQ(国家地区的ID)我想通过一个查询语句查询GA_WJRY的所有内容 其中WJRY_GJDQ 这项显示出国家地区的名称 而不是它的ID号
谢谢 帮下!!!!
在表GA_GJDQ中有GJDQ_ID,GJDQ_BM(国家编码),GJDQ_GJDQ(国家名称) 字段
在表GA_WJRY中有WJRY_ID,WJRY_NAME(人员姓名),WJRY_SEX(性别),WJRY_GJDQ(国家地区的ID)我想通过一个查询语句查询GA_WJRY的所有内容 其中WJRY_GJDQ 这项显示出国家地区的名称 而不是它的ID号
谢谢 帮下!!!!
FROM GA_WJRY LEFT JOIN GA_GJDQ
ON GA_WJRY.WJRY_GJDQ=GA_GJDQ.GJDQ_ID
FROM GA_WJRY T1
LEFT JOIN GA_GJDQ T2 ON T1.WJRY_GJDQ=T2.GJDQ_ID
select WJRY_ID,WJRY_NAME,WJRY_SEX,GJDQ_GJDQ
FROM ga_wjry a
left join ga_gjdq b
on a.wjry_gjdq=b.gjdq_id
declare @tb table (id int,vb varchar(10))insert into @ta select 1,'aa'
insert into @ta select 2,'bc'
insert into @ta select 3,'ccc'insert into @tb select 1,'2'
insert into @tb select 3,'58'
insert into @tb select 4,'67' --内连接简单写法select a.id,a.va,b.id,b.vb from @ta a,@tb b
where a.id=b.id--内连接select a.id,a.va,b.id,b.vb from @ta a inner join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a join @tb b
on a.id=b.id--左连接(左外连接)
--返回left join 子句中指定的左表的所有行,以及右表所匹配的行。select a.id,a.va,b.id,b.vb from @ta a left join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a left outer join @tb b
on a.id=b.id--右连接(右外连接)
--返回right join 子句中指定的右表的所有行,以及左表所匹配的行。select a.id,a.va,b.id,b.vb from @ta a right join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a right outer join @tb b
on a.id=b.id--完整外连接
--等同左连接+右连接select a.id,a.va,b.id,b.vb from @ta a full join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a full outer join @tb b
on a.id=b.id
--交叉连接
--没有两个表之间关系的交叉连接,将产生连接所涉及的表的笛卡尔积。select a.id,a.va,b.id,b.vb from @ta a cross join @tb bselect a.id,a.va,b.id,b.vb from @ta a,@tb b--自连接
--一个表和其本身连接。select a.id,a.va,b.id,b.va from @ta a,@ta b where a.id=b.id+1code]
declare @tb table (id int,vb varchar(10))insert into @ta select 1,'aa'
insert into @ta select 2,'bc'
insert into @ta select 3,'ccc'insert into @tb select 1,'2'
insert into @tb select 3,'58'
insert into @tb select 4,'67' --内连接简单写法select a.id,a.va,b.id,b.vb from @ta a,@tb b
where a.id=b.id--内连接select a.id,a.va,b.id,b.vb from @ta a inner join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a join @tb b
on a.id=b.id--左连接(左外连接)
--返回left join 子句中指定的左表的所有行,以及右表所匹配的行。select a.id,a.va,b.id,b.vb from @ta a left join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a left outer join @tb b
on a.id=b.id--右连接(右外连接)
--返回right join 子句中指定的右表的所有行,以及左表所匹配的行。select a.id,a.va,b.id,b.vb from @ta a right join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a right outer join @tb b
on a.id=b.id--完整外连接
--等同左连接+右连接select a.id,a.va,b.id,b.vb from @ta a full join @tb b
on a.id=b.idselect a.id,a.va,b.id,b.vb from @ta a full outer join @tb b
on a.id=b.id
--交叉连接
--没有两个表之间关系的交叉连接,将产生连接所涉及的表的笛卡尔积。select a.id,a.va,b.id,b.vb from @ta a cross join @tb bselect a.id,a.va,b.id,b.vb from @ta a,@tb b--自连接
--一个表和其本身连接。select a.id,a.va,b.id,b.va from @ta a,@ta b where a.id=b.id+1
b.[WJRY_ID],b.[WJRY_NAME],b.WJRY_SEX,a.GJDQ_GJDQ
from
GA_GJDQ a, GA_WJRY b
where
a.GJDQ_ID=b.WJRY_ID
from GA_GJDQ a,GA_WJRY b where a.GJDQ_ID= b.WJRY_GJDQ