how can i create a report where in data are located in different recordsets or tables?

i tried this one but it did'nt gave me the result expected:
for 2 TABLES:
Dim Rst As New ADODB.Recordset
MyQuery = "select * from spdr1017d, totrefund"
Set Rst = con.Execute(MyQuery)
Set DR40KWSRC.DataSource = Rst
DR40KWSRC.Show vbmodal