There are two tables:
Duzhexinxi
Tushu


The following statements suggest "FROM the sentence grammatical mistakes" :

RS3. Open the "select * from tushu JOIN duzhexinxi ON tushu. Jieshuren=duzhexinxi. Bianhao", conn, 1, 3

But to join innet or left and right are prompt "parameter is insufficient, looking forward to is 1",

RS3. Open the "select * from tushu inner JOIN duzhexinxi ON tushu. Jieshuren=duzhexinxi. Bianhao", conn, 1, 3

Tushu table inside determine how jieshuren fields, there is bianhao duzhexinxi fields,

Whether where is a problem????? Superior guidance,

CodePudding user response:

Whether where is a problem????? Superior guidance,

CodePudding user response:

Seek expert advice,

CodePudding user response:

What is your RS3 object?
General "Open" is for "database connection" operation, how to perform there "query operation"?

CodePudding user response:

I ask is: use the join united query, "FROM the sentence grammar error", or "parameter is insufficient, looking forward to is 1"

CodePudding user response:

Superior guidance,

CodePudding user response:

What database? If set to a case-sensitive?
His first post the SQL database query window to test,

CodePudding user response:

ACCESS database,

CodePudding user response:

Not set case-sensitive,

To question:

There are two tables:
Duzhexinxi
Tushu


The following statements suggest "FROM the sentence grammatical mistakes" :

RS3. Open the "select * from tushu JOIN duzhexinxi ON tushu. Jieshuren=duzhexinxi. Bianhao", conn, 1, 3

But to join innet or left and right are prompt "parameter is insufficient, looking forward to is 1",

RS3. Open the "select * from tushu inner JOIN duzhexinxi ON tushu. Jieshuren=duzhexinxi. Bianhao", conn, 1, 3

Tushu table inside determine how jieshuren fields, there is bianhao duzhexinxi fields,

Whether where is a problem????? Superior guidance,

CodePudding user response:

Stick conn connection string,

CodePudding user response:

references 9 f of123 response:

stick conn connection string,

In the module (other function is normal) :

 Public RS3 As New ADODB. You 
Public Sub SJK (conn) 
Conn. The ConnectionString="DRIVER=Microsoft Access DRIVER (*. MDB); DBQ="& amp; App. The Path & amp; "\ # xt. MDB; The PWD=08888... "
Conn. Open 
End Sub 

CodePudding user response:

Try not ODBC driver, convert the OLEDB:
Conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; App. The Path & amp; "\ # xt. MDB; The PWD=08888... "

CodePudding user response:

Conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; App. The Path & amp; "\ # xt. MDB; Password=08888... "

CodePudding user response:

A change of writing try
A,

 select * from tushu duzhexinxi b where a. ieshuren=b.b ianhao 

CodePudding user response:

The

refer to 12 floor of123 reply:

conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0. Data Source="& amp; App. The Path & amp; "\ # xt. MDB; Password=08888... "

Can't find the applicable ISDN

CodePudding user response:

The

reference 13 floor chewinggum reply:

change the writing try
A,

 select * from tushu duzhexinxi b where a. ieshuren=b.b ianhao 

Parameter is insufficient, looking forward to is 1.

CodePudding user response:

Put your SQL directly in the Access to the debugging,. Double-click directly on your MDB file,

CodePudding user response:

On the 14th floor aamiiLA

reference response:

Quote: refer to 12 floor of123 reply:

Conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; App. The Path & amp; "\ # xt. MDB; Password=08888... "

Can't find the applicable ISDN

in your project, some menu "engineering" - "reference", in the pop-up window, select Micosoft AxtiveX Data Objects 2.8 or above,

CodePudding user response:

refer to 17th floor of123 response:

Quote: refer to the 14 floor aamiiLA response:

Quote: refer to 12 floor of123 response:

Conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; App. The Path & amp; "\ # xt. MDB; Password=08888... "

Can't find the applicable ISDN

in your project, some menu "engineering" - "reference", in the pop-up window, select the Micosoft AxtiveX Data Objects 2.8 or above,

To question:

There are two tables:
Duzhexinxi
Tushu


The following statements suggest "FROM the sentence grammatical mistakes" :

RS3. Open the "select * from tushu JOIN duzhexinxi ON tushu. Jieshuren=duzhexinxi. Bianhao", conn, 1, 3

But to join innet or left and right are prompt "parameter is insufficient, looking forward to is 1",

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull