rini389 0 Newbie Poster

hai
i am getting the error " IErrorInfo.GetDescription failed with E_FAIL(0x80004005)." when trying to execute the following code

Dim cmd As New OleDb.OleDbCommand("(select regno from s1 where batch=" + bt + ") intersect (select regno from s2 where batch=" + bt + ")", con)

pls help me to solve this problem or tell me how to retrieve multiple rows from 2 or more tables using intersect

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.