SQL中某列中任何一个值在另一个集合中
如:tbStudBasicInfo.StudBookCardNumb in
(SELECT StudBookCardNumb
FROM tbStudBasicInfo AS tbStudBasicInfo_1
WHERE (StudClassID in ('34', '35', '36', '37', '38', '39', '40', '41', '42', '53', '54',
'55', '56', '57'))
怎么知道studbookcardnumb中的任何一个元素在select所选的元素中