主题：SELECT问题

cmd.CommandText = "Select * FROM {出库} INNER JOIN {采购明细} ON {采购明细}.型号= {出库}.型号"

 

什么意思？

改一下

 

cmd.CommandText = "Select {出库}.*, {采购明细}.供应商 FROM {出库} INNER JOIN {采购明细} ON {采购明细}.型号= {出库}.型号"

 数据肯定正确，是不是你还要加上年？

 

Dim cmd As New SQLCommand

Dim dt As DataTable

cmd.CommandText = "Select {出库}.*, {采购明细}.供应商 FROM {出库} INNER JOIN {采购明细} ON {采购明细}.型号= {出库}.型号"

dt = cmd.ExecuteReader()

'对临时进行分组统计

Dim b As New CrossTableBuilder("统计表111",dt)

b.HGroups.AddDef("供应商")

b.HGroups.AddDef("型号")
b.VGroups.AddDef("出库日期",DateGroupEnum.Year,"{0}年")
b.VGroups.AddDef("出库日期","{0}月")

b.Totals.AddDef("出库数量")

b.HorizontalTotal = True

b.VerticalTotal = True

Tables("采购管理_Table18").DataSource = b.BuildDataSource()

 

 改成这样，如果还错，就上传例子

 

cmd.CommandText = "Select {出库}.*, {采购明细}.供应商 FROM {出库} Left JOIN {采购明细} ON {采购明细}.型号= {出库}.型号"

 回复15楼，不是叫你把项目发上来，是叫你做一个新的例子，把两个表的数据弄进去发上来。

 测试了一下，数据正确啊。

 

 例子的哪一行的数据不正确？

 代码

 

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select *, (select top 1 供应商 from {采购明细} b where a.型号=b.型号) as 供应商 FROM {出库} a"
dt = cmd.ExecuteReader()
'对临时进行分组统计
Dim b As New CrossTableBuilder("统计表111",dt)
b.HGroups.AddDef("供应商")
b.HGroups.AddDef("型号")
b.VGroups.AddDef("出库日期","{0}月")
b.Totals.AddDef("出库数量")
b.HorizontalTotal = True
b.VerticalTotal = True
Tables("采购管理_Table2").DataSource = b.BuildDataSource()

 

嗯嗯，是有重复值。你把SQL语句执行一次看结果

 

http://www.foxtable.com/help/topics/1484.htm

 

 你想做一个模拟执行sql的窗口？

 

 你可以这样写，红色代码，换成你对应的sql语句

 

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.CommandText = "Select *, (select top 1 供应商 from {采购明细} b where a.型号=b.型号) as 供应商 FROM {出库} a"
dt = cmd.ExecuteReader()

 

Tables("采购管理_Table2").DataSource = dt