delete from tbl_car_top10 As tt, tbl_car_info As ii where ii.brand_id=@id and ii.cartype_id=tt.cartype_id //这行错了,------------------------------------------------------------------------------
更改成下面的語句即可.
delete tb1_car from tbl_car_top10 As tt, tbl_car_info As ii where ii.brand_id=@id and ii.cartype_id=tt.cartype_id
更改成下面的語句即可.
delete tb1_car from tbl_car_top10 As tt, tbl_car_info As ii where ii.brand_id=@id and ii.cartype_id=tt.cartype_id
这里的tbl_car是什么,好像没有这个东西
應該是tbl_car_top10, 就是你將要刪除記錄的表名.
改一下, 是tbl_car_info表.