两表联合查询sql语句 两个表查询的sql语句

select A.ID,A.发货单号,A.日期,A.价格,B.存货名称,B.数量,0 as 运费结算,0 as 状态 into AB from A inner join B on A.ID=B.ID 根据你运费结算和状态的类型,可以定义成''空来代替0

select a.*,b.* from a inner join b on a.id=b.字段2 order by a.字段3 desc,b.字段4 desc

select * from (select a.姓名编号,a.姓名,b.考试科目 as 科目,b.成绩,row_number. 说明: 1、上面的sql是按照成绩降序排列后取出每个姓名的第一条记录,如果想换成.

select kd_to as 目的地,'共计' + cast(count(kd_to) as nvarchar) + '单' as 总数 from kuaidi inner join towhere on kuaidi.to_type=towhere.to_type group by kd_to

select kd_to as 目的地, count(*) as 总数 from kuaidi, towhere where kuaidi.to_type = towhere.to_type group by kd_to order by count(*) desc

select a.no,a.name,b.subid,b.subname,c.score from a,b,c where a.no = c.no and b.subid = c.subid ;

把两个表都选上,选择你要的字段,然后在条件里面把关联的字段条件加上,例如下. 发布时间,这条语句并不一定可用,要对照你的表结构.如果有不清楚可以给我发信.

select id from 1 union select id2 fro 2

多表查询分为 内、外连接 外连接分为左连接(left join 或left outer join)、右连接(right join 或者 right outer join)、和完整外部连接 (full join 或者 full outer join) 左连接(left .

select A.MEDIID,B.PRICE from A,B where a.MEDIID=B.MEDIID