自己写了一个小例子你看下吧createtable#a(aint,bint)createtable#b(cint,bint)insert#avalues(1,23)insert#avalues(2,533)insert#avalues(3,243)insert#avalues(4,223)insert#bvalues(1,23)insert#bvalues(2,533)insert#bvalues(3,243)insert#bvalues(5,233)select*from#awhereain(selectcfrom#b)droptable#a,#b
|