您的位置首页百科问答

关于asp编程的一个简单语句

关于asp编程的一个简单语句

设已乎渗掘知的喊埋券号是岁核aNum, 以下SQL语句可以查出所有券号为aNum的人员信息:SELECT People.bianhao, People.xingming, People.shenfenzheng, People.bumen, People.danwei, Quan.pricetype, Quan.pricenum, Quan.duifou, Quan.riqi FROM People INNER JOIN Quan ON (People.bianhao = Quan.bianhao) WHERE Quan.pricenum = aNum