请教:SQL 2000 中的语法错误

[iazou]

删除MB002表中含有"56"的所有记录.

delete from test..INVMB
where MB002=
(select INVMB
from test
where MB002='56')



命令成功,但是执行时出现错误
提示:Invalid object name 'test'.

请教我错在哪里???谢谢

[areswang]

提示TEST对象无效

[areswang]

删哪个表的内容？MB002是表？还是字段？

[fa_ge]

到底哪个是数据库，哪个是表，哪个是字段

[alan352]

怎么好像是两个表啊？

[yesyesyes]

数据库,表,列,记录
没搞清

[xiangjin0106]

要清楚是删除表中记录

[giggsbj]

delete from test..INVMB
where MB002= '56'

[rouqu]

delete from test..INVMB
where MB002=
(select INVMB
from test
where MB002='56')

---------
test前面是数据库 后面摇身一变成表了...

[iazou]

谢谢 .
TEST 是数据库
INVMB 是表