ThenSub combinationFilter()
Dim oArea As RangeDim oLOAs ListObjectDim n As Long
Set oLO = Selection.ListObjectIf Not oLO Is Nothing Then
ReDim sColumn(1 To oLO.
这个查询在三个查找表ls、lo和ld的帮助下,从一个主表m、三个辅助表s、o和d获得了我想要的结果,但是它对每个字段都查询了一次。(SELECT GROUP_CONCAT(s.field1 SEPARATOR ', ') WHERE ls.mid=m.id AND ls.sid=s.id) (SELECT GROUP_CONCAT(o.field1 SEPARATOR ', ') WHERE lo.mid=m.id AND