access数据库,使用ADO方式现在有两张表,表A,表B,两张表中的字段都是一样的,分别是Name,Value,Time。现在我要根据字段Name对两表进行联合查询。查询代码如下:CString sql;
sql.Format("Select A.* B.* From A, B Into TempTable Where A.Name = '%s' AND B.Name = '%s'", AName, BName); 执行后报错,提示"Invalid Operation"如果将sql语句换成
sql.Format("Select A.* B.* From A, B Where A.Name = '%s' AND B.Name = '%s'", AName, BName); 执行后没有报错,但是在后面的查询时报错,提示"Item not found in this collection"请问应该如何解决?谢谢
sql.Format("Select A.* B.* From A, B Into TempTable Where A.Name = '%s' AND B.Name = '%s'", AName, BName); 执行后报错,提示"Invalid Operation"如果将sql语句换成
sql.Format("Select A.* B.* From A, B Where A.Name = '%s' AND B.Name = '%s'", AName, BName); 执行后没有报错,但是在后面的查询时报错,提示"Item not found in this collection"请问应该如何解决?谢谢
就算不报错,结果能对吗?
try
select * from (
select * from a
union all select * from b) as TempTable Where [name] like '%ABC%'
该这样写哈:
sql.Format("Select A.* B.* Into TempTable From A, B Where A.Name = '%s' AND B.Name = '%s'", AName, BName);
rs.Open(dbOpenDynaset,sql);<-这一步报错,提示:"syntax error in FROM clorse"还有,你最后写的那个'%ABC%'是什么意思?