高手,错在哪里呀?妹妹谢谢了
delete from Packageswhere PackageId in (SELECT P.PackageId
From Packages P inner join Packages_Products_Suppliers PPS
on P.PackageId = PPS.PackageId )= @pid --------------------编程问答-------------------- 最后= @pid是干吗的?
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)
http://feiyun0112.cnblogs.com/ --------------------编程问答-------------------- delete from Packages
where PackageId in (SELECT P.PackageId
From Packages P inner join Packages_Products_Suppliers PPS
on (P.PackageId = PPS.PackageId and P.PackageId= @pid))
试试行不? --------------------编程问答-------------------- SELECT 出来的是PackageId 一个集合,不能直接和PackageId直接比。。。 --------------------编程问答--------------------
同问 --------------------编程问答-------------------- ding. --------------------编程问答-------------------- delete from Packages
where PackageId in (SELECT P.PackageId
From Packages P inner join Packages_Products_Suppliers PPS
on P.PackageId = PPS.PackageId nad P.PackageId =@pid) --------------------编程问答-------------------- 又不是参数调用,干嘛要用“@”符号,即便是,如果操作的数据库是Access,那就不能这么写。
如果没用的参数调用,则将“@”改为“&”,并注意前后各留一空格,型如:
P.PackageId = PPS.PackageId )= @pid 改为 P.PackageId = PPS.PackageId )= & pid
补充:.NET技术 , VB.NET