|
表A |
|
|
|
表B |
|
|
|
查询表 |
|
|
A |
B |
C |
|
A1 |
B1 |
C1 |
|
A |
B |
C |
B1 |
C1 |
a1 |
N |
456 |
|
a1 |
f |
777 |
|
a1 |
Y |
789 |
f |
777 |
a1 |
Y |
789 |
|
b1 |
t |
888 |
|
b1 |
Y |
123 |
f |
999 |
b1 |
Y |
123 |
|
b1 |
f |
999 |
|
|
|
|
|
|
如上,通过统计后台数据表A与表B,得到查询表,Dim htzh As New SQLJoinTableBuilder("查询表","表A")
htzh.C
htzh.AddTable("表A","A","表B","A1")
htzh.AddCols("A","B", "C","B1","C1")
htzh.Filter= "B = 'Y'"
htzh.Filter= "B1= 'F'"
htzh.Build()
MainTable = Tables("查询表")
在按钮执行时,只对表B设置条件有用,表A设置条件无用,如何修改