Selecting from different tables. Pls Help..Thanx

[sand]

Hi,

I have a doubt. I am using microsoft access as my database. I want to extract various information from different tables based on one primary key, the user id. What i want is to extract information from the two tables based on the user id.

I also want deatils displayed only if present date corresponds to the date in another table. The matchNo corresponding to that date should also be the same as that of corresponding to the userid.

I have written the following code but i am not sure if i am correct. I hope someone can guide me. Thanx

P

rivate Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
        Dim dbCon As New OleDbConnection(ConnectionString)
        Dim dbCommand As OleDbCommand
        Dim MatricNo As String
        Dim day As Date
        Dim MatchNo As New Integer
        MatricNo = txtPMatricNo.Text
        day = day.Date
        dbCon.Open()
        dbCommand = New OleDbCommand("SELECT * FROM MatchesWSinglesRound1,MatchesMDoublesRound1,Matches WHERE MatchesMDoublesRound1.MatricNo = '" & MatricNo & "', MatchesWSinglesRound1 = '" & MatricNo & "',Matches.MatchDay = '" & day & "',Matches.MatchNo = '" & MatchesWSinglesRound1.MatchNo & "',Matches.MatchNo = '" & MatchesMDoublesRound1.MatchNo & "'", dbCon)
        dbCommand.ExecuteNonQuery()
        dbCommand.Dispose()
        dbCon.Close()
    End Sub