我在SQL2000中下面的这句是没问题的,可到了access里就会了错
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpath like '%0,3%' and Child=0 group by classname order by rootid,classid
那么在access里 ......
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpath like '%0,3%' and Child=0 group by classname order by rootid,classid
这句在SQL2000查询分析器里是没问题的
但在access里却不行
哪位高手帮看看问� ......
要组合4张表的查询，分别是A表，B表，C表，D表；
A表
Game_id Game_Name
1 abc
B表
Category_ID Category_Name Game_id
1 A 1
&nb ......
string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
string sql = "insert into times(time) values('" + DateTime.Now + "' )";
OleDbConnection con = new OleDbConnection(conne ......
Public Rs As New ADODB.Recordset
Public Conn As New ADODB.Connection
Private Sub Command1_Click()
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Persist Security Info=False"
Rs.CursorLocation = ......
ACCESS数据库中有一个tablename表，设计如下
编号,书名,作者,出版时间,出版社,ISBN,目录,简介
其中除“编号”为自动编号外，其它都为“备注”
其中"编号"维一，在“ISBN”中有的为空值，有的为ISBN号，但ISBN号有重复，怎样编写SQL语言，使ISBN中为空值的项保留，有值的项只显示一次（也� ......
最新文章 : access