急用，跪请高手指教，多给分

[sql1]

A表

cxdm lsj
001 2.0
002 5.0
003 7.0

B表
id cxdm
01 001
01 002

想得到C表

id cxdm lsj
01 001 2.0
01 002 5.0

请高手指教？？？？？

[天下如山]

select B.id,B.cxdm,A.lsj from B left join A on B.cxdm=A.cxdm

[shizheyangde]

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),cxdm varchar(10))
insert into tb values('01','001')
insert into tb values('01','002')

select tb.id,ta.cxdm,ta.lsj
from ta inner join tb on ta.cxdm=tb.cxdm

drop table ta
drop table tb

[shizheyangde]

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),cxdm varchar(10))
insert into tb values('01','001')
insert into tb values('01','002')

select tb.id,ta.cxdm,ta.lsj
from ta inner join tb on ta.cxdm=tb.cxdm

drop table ta
drop table tb

/**
ID  cxdm    lsj 
----------- -----------
01	001  	2.0
01	002	    5.0

(2 行受影响)
**/

[wangkun520]

select b.id,b.cxdm,a.lsj
from A表 a,B表 b
where a.cxdm=b.cxdm

[viqn7qdnt]

[Quote=引用 10 楼 dawugui 的回复:]
SQL code
create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),……
[/Quote]

up

[zhangbiaoandbill]

连接查询。。。基础

[bourbon1795]

select B.id,B.cxdm,A.lsj from B left join A on B.cxdm=A.cxdm

[fengyun142415]

select b.id,b.cxdm,a.lsj
from A表 a,B表 b
where a.cxdm=b.cxdm

[chuanzhang5687]

create table A (
cxdm varchar(10),
lsj varchar(10)
)

insert into A values('001','2.0')
insert into A values('002','5.0')
insert into A values('003','7.0')
create table B (
id varchar(10),
cxdm varchar(10)
)
insert into B values('01','001')
insert into B values('01','002')


select b.id,a.cxdm,a.lsj
from a inner join b on a.cxdm=b.cxdm
drop table b
drop table a

[fpzgm]

问题和分数有点。。直接join下。。

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),cxdm varchar(10))
insert into tb values('01','001')
insert into tb values('01','002')
go

--方法一
select tb.* , ta.lsj from tb , ta where tb.cxdm = ta.cxdm
--方法二
select tb.*, ta.lsj from tb inner join ta on tb.cxdm = ta.cxdm


drop table ta , tb

/*
id         cxdm       lsj        
---------- ---------- ---------- 
01         001        2.0
01         002        5.0

（所影响的行数为 2 行）

*/

[cloud1215]

楼上的语句，楼主试试.

[alfred_2006]

呵呵，如果试过，那就是环境有问题了

[zengjiaqin]

上面都回答了

[opou]

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),cxdm varchar(10))
insert into tb values('01','001')
insert into tb values('01','002')

select b.id ,a.cxdm,a.lsj from ta a ,tb b where a.cxdm = b.cxdm

---------
id cxdm lsj
01 001 2.0
01 002 5.0 

[Fabulous]

这个我居然会做

[zhangsuyunpk521]

[Quote=引用 10 楼 dawugui 的回复:]
SQL code
create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),……
[/Quote]
+1

[破Feel]

没把握住表现的机会 ……

[破Feel]

[Quote=引用 7 楼 shizheyangde 的回复:]
SQL code

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10……
[/Quote]

可以

[abuying]

[Quote=引用 5 楼 sql1 的回复:]

select tb.id,ta.cxdm,ta.lsj
from ta inner join tb on ta.cxdm=tb.cxdm

结果只有一个值，不是两个值。这个我试过，不行。
[/Quote]
那就试一下

select tb.id,ta.cxdm,ta.lsj
from ta ,tb where ta.cxdm=tb.cxdm

select tb.id,ta.cxdm,ta.lsj
from ta left join tb on ta.cxdm=tb.cxdm

[dawugui]

create table ta(cxdm varchar(10),lsj varchar(10))
insert into ta values('001','2.0')
insert into ta values('002','5.0')
insert into ta values('003','7.0')
create table tb(id varchar(10),cxdm varchar(10))
insert into tb values('01','001')
insert into tb values('01','002')
go

select tb.* , ta.lsj from tb , ta where tb.cxdm = ta.cxdm

drop table ta , tb

/*
id         cxdm       lsj        
---------- ---------- ---------- 
01         001        2.0
01         002        5.0

（所影响的行数为 2 行）

*/