MYSQL数据源
需求：将“明细表：料号、品名、单位、数量、金额、采购单号”与“主表：采购单号、供方、日期”，合并为一张表：料号、品名、单位、数量、金额、采购单号、供方、日期
Dim db = HySql.DataBaseFactory.CreateDatabase("CG")
Dim Sql2 = "selec--t * from cgzb a Inner Join cgmx b On {cgzb}.[采购单号] = {cgmx}.[采购单号]) ;"
Dim dt2 As system.data.DataTable = db.ExecuteDataSet(Sql2).Tables(0)
Dim t2 As Table = e.Form.Controls("Table1").Table
上面执行后，报错：
You have an error in your SQL syntax; check the manual that corresponds to your MySQ--L server version for the right syntax to use near '}.[采购单号] = {cgmx}.[采购单号])' at line 1
加好友 
发短信
Post By：2023/8/9 10:14:00 [只看该作者]
