mysql - Select using where and different tables -

mysql - Select using where and different tables -

i have code:

dim oledbcon1 new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0;data source=c:\users\utilizador.utilizador-pc\documents\visual studio 2013\projects\windowsapplication1\windowsapplication1\doc_vendas_cab.mdb;persist security info=true") oledbcon1.open() dim oledbstr1 string = "select mov_venda_lin.ftlquantidade, mov_venda_lin.fltprecounitario, tbl_gce_artigosprecos.strcodartigo,tbl_gce_artigosprecos.intnumero,tbl_gce_vendedores.strnome " & _ "from mov_venda_lin,tbl_gce_artigosprecos,tbl_gce_vendedores, mov_venda_cab " & _ "where (mov_venda_lin.strcodartigo = tbl_gce_artigosprecos.strcodartigo) , (mov_venda_lin.strcodseccao = mov_venda_cab.strcodseccao) , (mov_venda_lin.intnumero = mov_venda_cab.intnumero) , (mov_venda_cab.intcodvendedor = tbl_gce_vendedores.intcodigo);" dim oledbconcomm1 new oledb.oledbcommand(oledbstr1, oledbcon1) dim olebddr oledb.oledbdatareader = oledbconcomm1.executereader oledbcon1.open()

i want select , relate info doesn't work error:

an unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll

additional information: there no value given 1 or more required parameters.

can help me? in advance.

mysql vb.net select oledb where-clause