HelpINNER JOIN query in vb.net 2008

I need help with this code..pls tell me whats the correct code for this..

Public Sub Join()

con.open()
dim dt as new DataTable("Table1")
dim rs as new oledb.OledbDataAdapter("Select Table1.clmDate , Table2.clmAMPM from Table1 Inner JOIN Table2 On Table1.ID =
Table2.ID")

rs.fill(dt)
datagridview1.datasource = dt
datagridview1.refresh()
label1.text = dt****ws.count

rs.dispose()

con.close

End Sub

Well to start I cannot see the entire code. Second what are you wanting it to do exactly? If something is selected from one table it will be selected in another?

Try