请哪个大侠帮个忙给个access,增删查改SQL语句的例子!!还有帮忙
select top 4 [shop].id,shoptype,name,pattern,text,shopimg,show,[shop].adddate from [shop] inner join [t_shop] on (t_shopid=t_shop.id) where show=1这个连接access语法哪有错误谢谢大家了
select top 4 [shop].id,shoptype,name,pattern,text,shopimg,show,[shop].adddate from [shop] inner join [t_shop] on (t_shopid=t_shop.id) where show=1这个连接access语法哪有错误谢谢大家了
SELECT [TbArticle.nId], [TbArticle.strTitle], dtCreate, strContent, strTypeTitle,
[TbArticleType.nId], [TbArticleType.strTitle]
FROM VwArticle
WHERE ([TbArticle.nId] = ?)
INSERT INTO `TbArticle` (`strTitle`,`strContent`, `strTypeTitle`) VALUES (?, ?, ?)
UPDATE TbArticle
SET strTitle = ?, strContent = ?, strTypeTitle = ?
WHERE (nId = ?)
DELETE FROM TbArticle
WHERE (nId = ?)? 是参数
还有 你的 show字段是啥类型的?系统提示错误是什么