in below code there is syntax error in from Clause but i think every thing looks fine iam using access database thx and relation is fine between thes two table

Public Function GetGridData() As DataTable
        Dim dt As New DataTable
        Try
            Dim con As New Connection()
            Dim cmd As New OleDbCommand
            cmd.Connection = con.con
            cmd.Connection.Open()

             Dim da = New OleDbDataAdapter("SELECT tblBill.Description,tblBillDetail.CustomerName from tblBill join tblBillDetail on tblBill.Receipt=tblBillDetail.Receipt", con.con)
                        da.Fill(dt)

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        Return dt

    End Function

I think Access is a bit more picky and needs to be told explicitly what kind of JOIN you are performing.
I suggest that you use either INNER JOIN or OUTER JOIN instead of just JOIN.
For more detail I also suggest that you read up a bit about using JOINs in Access.

I think Access is a bit more picky and needs to be told explicitly what kind of JOIN you are performing.
I suggest that you use either INNER JOIN or OUTER JOIN instead of just JOIN.
For more detail I also suggest that you read up a bit about using JOINs in Access.

ok thx i have done it with ur suggestions

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.