2张表关联的数据怎么提出数据出来

[nply2008]

A表
id user_no product_tc statu
1 2 ab 1
2 2 cd 1
3 3 ab 2
4 3 cd 2
5 2 el 1

B表
id product_tc price
1 ab 50
2 cd 20
3 el 35

我要得到结果是：
id user_no product_tc statu price
1 2 ab 1 50
2 2 cd 1 20
3 3 ab 2 50
4 3 cd 2 20
5 2 el 1 35

急啊，昨天一晚上没有睡还没有想出来，下面就没有办法继续做了，晕。

[ChinaJiaBing]

----try

declare @A table (id int,user_no int,product_tc nvarchar(10),statu int)
insert into @A select 1,2,'ab',1
     union all select 2,2,'cd',1
     union all select 3,3,'ab',2
     union all select 4,3,'cd',2
     union all select 5,2,'el',1
declare @B table (id int,product_tc nvarchar(10),price int)
insert into @B select 1,'ab',50
     union all select 2,'cd',20
     union all select 3,'el',35
select a.id,a.user_no,a.product_tc,a.statu,b.price from @A a join  @B b 
              on a.product_tc=b.product_tc

[fwacky]

left join

[昵称被占用了]

select a.id,a.user_no,a.product_tc,b.statu price
from a,b
where a.product_tc = b.product_tc

[Mr_Nice]

select A.* ,B.price
from A
left join B on A.product_tc = B.product_tc 

看起来好象是这样！

[--小F--]

select
 a.*,b.price
from
 a left join b
on
 a.id=b.id

[东那个升]

select a.*,b.price from  a ,b  where a.product_tc= b.product_tc 

[fwacky]

select A.*,B.price
from A left join B on A.product_tc =B.product_tc

[dawugui]

select a.* , b.price from a , b where a.product_tc = b.product_tc

[ws_hgo]

select a.id,a.user_no,a.product_tc,b.statu price
from a,b
where a.product_tc = b.product_tc