將第二個表的結構說清楚，和第一個表什么關系？第二個中要求有什么數據？

你選擇的時候 用Select 只選擇你需要的字段就行了

你猜有人能看懂什么意思么？
你是只要這特定的幾行呢？還是要把這樣的規律運用到整張表上？

select "21","30","31","40","41","50","51","60","61","70","71","80","81","90","91","0120","0121","01230" from t where id=367
union all
select "20","21","30","31","40","41","50","51","60","61","70","71","80","81","90","91","0120","0121" from t where id=368
union all
select "11","20","21","30","31","40","41","50","51","60","61","70","71","80","81","90","91","0120" from t where id=369
union all
select "10","11","20","21","30","31","40","41","50","51","60","61","70","71","80","81","90","91" from t where id=370
union all
select "01","10","11","20","21","30","31","40","41","50","51","60","61","70","71","80","81","90" from t where id=371
union all
select "00","01","10","11","20","21","30","31","40","41","50","51","60","61","70","71","80","81" from t where id=372

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

create proc st_jsjbj
as
insert into AB select A.發貨單號,A.日期,A.價格,B.存貨名稱,B.數量 from A inner join B on A.Id=B.id
go

alter table AB add 運費結算 varchar(20) null,狀態 varchar(20) null
execute st_jsjbj

你試試

不知道為什么要這樣做，有疑問:
1.既然是關系型數據庫，為什么還要個合并AB表(假設稱C表)的Table出現。
2.既然A,B表發生更改，C表也改變，又為何不要view來做？
3.增加的兩個欄位 運費結算 狀態 為何不直接不放在A表呢？

如果非得這樣做的話，Oracle數據庫,你可以
create table C as
( select a.ID, a.發貨單號, a.日期, a.價格
b.存貨名稱,b. 數量,
null 運費結算,null 狀態
from a,b
where a.id=b.id(+)
);
再將A,B對應寫一個Trigger（觸發器）來改變C表

總之,這種方式我怎么也想不通

假設第一個表表名為a，第二個為b；
1）select
a.姓名,b.借書證號,a.圖書號,a.借閱時間
from
a
inner
join
b
on
a.借書證號=b.借書證號
and
b.系別='電子商務';
2)select
b.姓名,a.圖書號,a.借書證號,b.系別
from
a,b
where
a.借書證號
in
(select
借書證號
from
a
where
借閱時間<2002/11/30);
第一個用的連接查詢即：inner
join
第二個用的嵌套查詢即：in
(select
借書證號
from
a
where
借閱時間<2002/11/30);

create table t1(pk1 int,pk2 nvarchar(10),name nvarchar(10),val int, primary key(pk1,pk2))