求查询以下下结果的sql语句

Question

本帖最后由 gdhwj 于 2012-09-06 19:27:06 编辑

Answer 1

insert into cardrptsum select 2,4407,61,15,'沙'    ,16,'沙南出',22,'2012-08-13 00:00:00',1,10099,'F',64,66,0,0,66,0,0,0,67691731,67691796,'67691731~67691796',66,0
insert into cardrptsum select 2,4407,61,17,'威'    ,20,'威出口',22,'2012-08-13 00:00:00',1,10094,'G',22,113,7,0,113,0,0,0,67749156,67749268,'67749156~67749268',113,0
insert into cardrptsum select 2,4407,61,9, '麻'  , 10, '麻东出',12,'2012-08-13 00:00:00',1,10151,'H',186,38,11,0,38,0,0,0,64684575,64684612,'64684575~64684612',38,0
insert into cardrptsum select 2,4407,61,9, '麻'  , 12, '麻西出',23,'2012-08-13 00:00:00',1,10154,'I',154,32,0,0,32,0,0,1,64572260,64572292,'64572260~64572292',33,0
insert into cardrptsum select 2,4407,61,9, '麻'  , 10, '麻东出',12,'2012-08-13 00:00:00',1,10151,'H',153,9,1,0,9,0,0,0,64684613,64684621,'64684613~64684621',9,0
insert into cardrptsum select 2,4407,61,11,'洪'    ,14,'洪出口',22,'2012-08-13 00:00:00',1,10114,'K',79,18,0,0,18,0,0,0,67644802,67644819,'67644802~67644819',18,0
insert into cardrptsum select 2,4407,61,15,'沙'    ,16,'沙南出',22,'2012-08-13 00:00:00',1,10099,'F',61,11,1,0,11,1,0,0,67691797,67691808,'67691797~67691808',12,0
insert into cardrptsum select 2,4407,61,15,'沙'    ,16,'沙南出',23,'2012-08-13 00:00:00',1,10130,'M',41,24,0,0,24,0,0,0,67793221,67793244,'67793221~67793244',24,0
insert into incardrptsum select 1,4407,61,9, '麻'  ,9,   '麻东入',33,'2012-08-13 00:00:00',1,10145,'C',136,44,2,0,0,1
insert into incardrptsum select 1,4407,61,7, '南'    ,7, '南南入',31,'2012-08-13 00:00:00',1,10006,'B',169,125,10,2,0,0
insert into incardrptsum select 1,4407,61,7, '南'    ,7, '南南入',31,'2012-08-13 00:00:00',1,10006,'B',201,0,0,26,6,14
insert into incardrptsum select 1,4407,61,11,'洪'    ,13,'洪入口',12,'2012-08-13 00:00:00',1,10111,'A' ,2,59,4,6,0,0
insert into incardrptsum select 1,4407,61,9, '麻'  ,9,   '麻东入',33,'2012-08-13 00:00:00',1,10145,'C',131,34,0,0,0,0
insert into incardrptsum select 1,4407,61,11,'洪'    ,13,'洪入口',12,'2012-08-13 00:00:00',1,10111,'A',69,1,0,0,0,0
insert into incardrptsum select 1,4407,61,11,'洪'    ,13,'洪入口',12,'2012-08-13 00:00:00',1,10111,'A',87,0,0,2,0,0
insert into incardrptsum select 1,4407,61,11,'洪'    ,13,'洪入口',13,'2012-08-13 00:00:00',1,10111,'A' ,52,15,0,3,0,0
insert into incardrptsum select 1,4407,61,17,'威'    ,19,'威入口',11,'2012-08-13 00:00:00',1,10072,'D',5,6,0,0,0,1
insert into incardrptsum select 1,4407,61,15,'沙'    ,15,'沙南入',12,'2012-08-13 00:00:00',1,10068,'E',8,156,4,2,0,4

Answer 2

sql同时查询两个表，相同字段显示。不相同字段列显示 ，1表没有的字段显示0，2表也是同样

Answer 3

select lanetypeno,AreaNo,RoadNo,stationno,StationName,SquareNo,SquareName,
LaneNo,SquadDate,SquadNo,OperatorNo,OperatorName,CardBoxNo,0,0,0,0,0,cashcard,freecard,
unpaycard,cardvoice,etcvoice,officevoice,PaperVoice,invoiceidmin,invoiceidmax,inv,sumvoice,BadVoice 
from cardrptsum
union all
select LaneTypeNo,AreaNo,RoadNo,StationNo,StationName,SquareNo,SquareName,LaneNo,SquadDate,SquadNo,
OperatorNo,OperatorName,CardBoxNo,CashCard1,CashCard2,CashCard3,CashCard4,CashCard5,0,0,0,0,0,0,0,0,0,'0',0,0 from incardrptsum

Answer 4

大概明白意思了。
用union all。
没有的字段用''或者0。

Answer 5

大概看明白意思了。
用union all实现。
没有的字段用''或者0代替。