主题：[求助]如何提取二个数具表后台的数具.

请教各位:
有二个表,如何设置如下公式将二个表的相同列的内容提取到DATALIST中.


Dim cm1 As winform.combobox = e.form.Controls("combobox1")
Dim dt3 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker3")
Dim dt4 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker4")
Dim dst4 As WinForm.DataList = e.Form.Controls("DataList4")
Dim cmd As New SQLCommand

cmd.CommandText = "SELECT 日期,收支,摘要,币种,金额 FROM {办工开支} WHERE 收支帐号 = '" & cm1.value & "' and 日期 >= #" & dt3.value & "# AND 日期 <= #" & dt4.value & "#"
dst4.DataTable = cmd.ExecuteReader()
dst4.Build()

Dim cmd1 As New SQLCommand

cmd1.CommandText = "SELECT 日期,收支,摘要,币种,金额 FROM {销帐录入} WHERE 收支帐号 = '" & cm1.value & "' and 日期 >= #" & dt3.value & "# AND 日期 <= #" & dt4.value & "#"
dst4.DataTable = cmd.ExecuteReader()
dst4.Build()