Why inner join is not supported?

[luigicannavaro]

Hi,

I did the following:

rs2.open "SELECT keywords.*, economictheory.* FROM keywords INNER JOIN economictheory ON keywords.keyword in ('" & strKeyword2 & "') and idx=id " ,conn, adOpenForwardOnly, adLockReadOnly, adCmdText

BUT it gives the following message:

Microsoft JET Database Engine error '80040e14'

Join expression not supported.

WHY?

Best regards,

Luigi:confused:

[brazenskies]

try...


rs2.open "SELECT keywords.*, economictheory.* FROM keywords INNER JOIN economictheory ON kewords.idx=economictheory.id where keywords.keyword in ('" & strKeyword2 & "')" ,conn, adOpenForwardOnly, adLockReadOnly, adCmdText