求一组SQL2000 select 语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 其中 a.sysserialno=b.sysserialno 已知 partno 其中一个值查出结果要包含 a.sysserialno b中 partno已知值 和 partno 另一个值a 表sysserialno sepno-------------------------- PSM26C072182106FAD2701 3PSM26C072182106FAE2701 4PSM26C072182106FAF2701 5PSM26C072182106FB02701 6PSM26C072182106FB12701 7PSM26C072182106FB22701 8PSM26C072182106FB32701 9PSM26C072182106FB42701 10PSM26C072182106FB52701 11PSM26C072182106FB62701 12b 表sysserialno partno-----------------------------------------PTU5AE20550270F2E02700 KN.2GB0H.009PTU5AE20550270F2E02700 MB.U2101.004PTU5AE20550270D4962700 KN.2GB0H.009PTU5AE20550270D49C2700 KH.01K08.008PTNBN090110270EAE32701 CKPTNBN09011PTU5AE20550270D49C2700 1A02WTNU5-600PTNBN090110270EB182701 CKPTNBN09011PTU5AE20550270F01C2700 KN.2GB0H.009PTU5AE20550270F01D2700 KH.01K08.008PTU5AE20550270F2E02700 1A02WTNF5-600 select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno = '某值' a.sysserialno=b.sysserialno?那搞些相等的样本数据来嘛,目测没一个相等的 select * from a ,b t where a.sysserialno=t.sysserialno and exist(select 1 from bwhere partno='已知' and sysserialno =t.sysserialno) 重新表达如下select top 10 sysserialno,productdesc from mfsysproduct a(nolock) sysserialno productdescPSM26C072182106FAD2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FAE2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FAF2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB02701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB12701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB22701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB32701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB42701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB52701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB62701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEselect top 10 sysserialno,partno from mfsyscserial b(nolock) sysserialno partno PTU5AE20550270F2E02700 KN.2GB0H.009PTU5AE20550270F2E02700 MB.U2101.004PTU5AE20550270D4962700 KN.2GB0H.009PTU5AE20550270D49C2700 KH.01K08.008PTNBN090110270EAE32701 CKPTNBN09011PTU5AE20550270D49C2700 1A02WTNU5-600PTNBN090110270EB182701 CKPTNBN09011PTU5AE20550270F01C2700 KN.2GB0H.009PTU5AE20550270F01D2700 KH.01K08.008PTU5AE20550270F2E02700 1A02WTNF5-600表A和表B的 连接条件是sysserialno 字段只知道partno = 'KN.2GB0H.009'求查出的结果集要包含 a.sysserialno b.partno='KN.2GB0H.009' 和partno 的其它值 select top 10 sysserialno,productdesc from mfsysproduct a(nolock) sysserialno productdesc----------------------------------------------------------------PSM26C072182106FAD2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FAE2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FAF2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB02701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB12701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB22701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB32701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB42701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB52701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEPSM26C072182106FB62701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEselect top 10 sysserialno,partno from mfsyscserial b(nolock) sysserialno partno -----------------------------------------PTU5AE20550270F2E02700 KN.2GB0H.009PTU5AE20550270F2E02700 MB.U2101.004PTU5AE20550270D4962700 KN.2GB0H.009PTU5AE20550270D49C2700 KH.01K08.008PTNBN090110270EAE32701 CKPTNBN09011PTU5AE20550270D49C2700 1A02WTNU5-600PTNBN090110270EB182701 CKPTNBN09011PTU5AE20550270F01C2700 KN.2GB0H.009PTU5AE20550270F01D2700 KH.01K08.008PTU5AE20550270F2E02700 1A02WTNF5-600表A和表B的 连接条件是sysserialno 字段只知道partno = 'KN.2GB0H.009'求查出的结果集要包含 a.sysserialno b.partno='KN.2GB0H.009' 和partno 的其它值 select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno = 'KN.2GB0H.009' 楼上查出的结果集中只有partno = 'KN.2GB0H.009' 的所有记录 没有结果三,,sysserialno两表中没有相同的 select a.sysserialno,b.partno from a right outer join b on a.sysserialno = b.sysserialno where b.partno = 'KN.2GB0H.009' 求查出的结果集要包含 a.sysserialno=b.sysserialno 和 b.partno='KN.2GB0H.009' 和partno 的其它值 --不太懂意思select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno = 'KN.2GB0H.009'union select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno != 'KN.2GB0H.009' b.partno='KN.2GB0H.009'推出b.sysserialno='PTU5AE20550270D49C2700'推出a.sysserialno = b.sysserialno的结果是空,因为a.sysserialno都是'PSM26C072182106FAD2701'我就纳闷了...在你的测试数据下,要a.sysserialno=b.sysserialno这个条件和A表干嘛... select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno = '某值' 触发器更新字段问题 SQL 数据排序问题~~ 急 還有一點問題,求SQL語句 我在数据库里面只建两个表,我想在这两张表建立外键,不建第三张表做关系表,可以吗? 关于统计个数的问题 这个问题怎么解决?各位高手进来看看,在线等,我都弄2天了,邹老大也进来指导啊 十万火急,此题关乎我的命运啊....谢谢!!!!!1 已知表名,如何写SQL语句来判断数据库中是否存在这样的表? 求SQL语句 难题 sql语句问题 sql统计记录数~! 关于字符串的数字相加的问题
已知 partno 其中一个值
查出结果要包含 a.sysserialno b中 partno已知值 和 partno 另一个值a 表
sysserialno sepno
--------------------------
PSM26C072182106FAD2701 3
PSM26C072182106FAE2701 4
PSM26C072182106FAF2701 5
PSM26C072182106FB02701 6
PSM26C072182106FB12701 7
PSM26C072182106FB22701 8
PSM26C072182106FB32701 9
PSM26C072182106FB42701 10
PSM26C072182106FB52701 11
PSM26C072182106FB62701 12b 表
sysserialno partno
-----------------------------------------
PTU5AE20550270F2E02700 KN.2GB0H.009
PTU5AE20550270F2E02700 MB.U2101.004
PTU5AE20550270D4962700 KN.2GB0H.009
PTU5AE20550270D49C2700 KH.01K08.008
PTNBN090110270EAE32701 CKPTNBN09011
PTU5AE20550270D49C2700 1A02WTNU5-600
PTNBN090110270EB182701 CKPTNBN09011
PTU5AE20550270F01C2700 KN.2GB0H.009
PTU5AE20550270F01D2700 KH.01K08.008
PTU5AE20550270F2E02700 1A02WTNF5-600
where partno='已知' and sysserialno =t.sysserialno)
select top 10 sysserialno,productdesc from mfsysproduct a(nolock) sysserialno productdesc
PSM26C072182106FAD2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FAE2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FAF2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB02701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB12701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB22701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB32701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB42701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB52701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB62701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEselect top 10 sysserialno,partno from mfsyscserial b(nolock)
sysserialno partno
PTU5AE20550270F2E02700 KN.2GB0H.009
PTU5AE20550270F2E02700 MB.U2101.004
PTU5AE20550270D4962700 KN.2GB0H.009
PTU5AE20550270D49C2700 KH.01K08.008
PTNBN090110270EAE32701 CKPTNBN09011
PTU5AE20550270D49C2700 1A02WTNU5-600
PTNBN090110270EB182701 CKPTNBN09011
PTU5AE20550270F01C2700 KN.2GB0H.009
PTU5AE20550270F01D2700 KH.01K08.008
PTU5AE20550270F2E02700 1A02WTNF5-600表A和表B的 连接条件是sysserialno 字段
只知道partno = 'KN.2GB0H.009'
求查出的结果集要包含 a.sysserialno b.partno='KN.2GB0H.009' 和partno 的其它值
----------------------------------------------------------------
PSM26C072182106FAD2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FAE2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FAF2701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB02701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB12701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB22701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB32701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB42701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB52701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AME
PSM26C072182106FB62701 VTM261/PDCE2180/512/80G/SM+/LiunxXW/AMEselect top 10 sysserialno,partno from mfsyscserial b(nolock)
sysserialno partno
-----------------------------------------
PTU5AE20550270F2E02700 KN.2GB0H.009
PTU5AE20550270F2E02700 MB.U2101.004
PTU5AE20550270D4962700 KN.2GB0H.009
PTU5AE20550270D49C2700 KH.01K08.008
PTNBN090110270EAE32701 CKPTNBN09011
PTU5AE20550270D49C2700 1A02WTNU5-600
PTNBN090110270EB182701 CKPTNBN09011
PTU5AE20550270F01C2700 KN.2GB0H.009
PTU5AE20550270F01D2700 KH.01K08.008
PTU5AE20550270F2E02700 1A02WTNF5-600表A和表B的 连接条件是sysserialno 字段
只知道partno = 'KN.2GB0H.009'
求查出的结果集要包含 a.sysserialno b.partno='KN.2GB0H.009' 和partno 的其它值
没有结果三,,sysserialno两表中没有相同的
select a.sysserialno,b.partno from a
right outer join b on a.sysserialno = b.sysserialno
where b.partno = 'KN.2GB0H.009'
--不太懂意思
select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno = 'KN.2GB0H.009'
union
select a.* , b.* from a , b where a.sysserialno = b.sysserialno and b.partno != 'KN.2GB0H.009'
推出
b.sysserialno='PTU5AE20550270D49C2700'
推出
a.sysserialno = b.sysserialno的结果是空,
因为a.sysserialno都是'PSM26C072182106FAD2701'
我就纳闷了...在你的测试数据下,要a.sysserialno=b.sysserialno这个条件和A表干嘛...