SELECT company.coname, [user].username
FROM company INNER JOIN
[user] ON company.userid = [user].userid
WHERE (company.coname LIKE ?)以上语句在sqlserver中可以执行
为什么在access中无法执行呢?我用的vs2005
在vs2005的数据库查询中
copy进去以上代码
就变成了
SELECT company.coname, [user].username
FROM (company INNER JOIN
[user] ON company.userid = [user].userid)
WHERE (company.coname LIKE ?)而且无法执行~郁闷
谢谢各位大大~:)~
FROM company INNER JOIN
[user] ON company.userid = [user].userid
WHERE (company.coname LIKE ?)以上语句在sqlserver中可以执行
为什么在access中无法执行呢?我用的vs2005
在vs2005的数据库查询中
copy进去以上代码
就变成了
SELECT company.coname, [user].username
FROM (company INNER JOIN
[user] ON company.userid = [user].userid)
WHERE (company.coname LIKE ?)而且无法执行~郁闷
谢谢各位大大~:)~
Select company.coname, [user].username
FROM company , [user]
WHERE company.userid = [user].userid
AND (company.coname LIKE ?)
为什么一copy到vs2005开发工具的那个查询中
就变成了这个样子呢
SELECT company.coname, [user].username
FROM (company INNER JOIN
[user] ON company.userid = [user].userid)
WHERE (company.coname LIKE ?)而且无法运行
对阿
一copy到vs2005的开发工具里面去
它就自动给改
然后就无法执行
郁闷
ACCESS是支持這種寫法的。Select company.coname, [user].username
FROM company , [user]
WHERE company.userid = [user].userid
无法通过~~郁闷~
paoluo(一天到晚游泳的鱼)按照您说的不行啊~
无法通过~~郁闷~
------------不可能啊,實際上這兩種寫法在ACCESS中都是沒有問題的。SELECT company.coname, user.username
FROM company, [user]
WHERE company.userid=user.userid
SELECT company.coname, [user].username
FROM company INNER JOIN [user] ON company.userid = [user].userid