Type mismatch in expression

[rellaboyina]

Hi,

I am a newbie to this forum and I want some help from you.

I want to extract some data using jdbc by connecting to the Ms-Access database. When I tried to extract the data from two tables using a query which involves the "join", I have faced a problem stating that "Type mismatch in expression".

But when I tried to retrieve the data from a single table using a simple query, the code is working fine.

Here I am posting my query:

String qry="select TT.PATENT_SK, TTD.STATE_NAME from TRACKER TT,TRACKER_DICT TTD where TT.KEY=TTD.KEY" ;

where I am joining two tables TRACKER and TRACKER_DICT to retrieve the columns PATENT_SK, STATE_NAME.

Any help in this regard will be appreciated and of great help to me and thanks alot in advance.

[JosAH]

Hi,

I am a newbie to this forum and I want some help from you.

I want to extract some data using jdbc by connecting to the Ms-Access database. When I tried to extract the data from two tables using a query which involves the "join", I have faced a problem stating that "Type mismatch in expression".

But when I tried to retrieve the data from a single table using a simple query, the code is working fine.

Here I am posting my query:

String qry="select TT.PATENT_SK, TTD.STATE_NAME from TRACKER TT,TRACKER_DICT TTD where TT.KEY=TTD.KEY" ;

where I am joining two tables TRACKER and TRACKER_DICT to retrieve the columns PATENT_SK, STATE_NAME.

Any help in this regard will be appreciated and of great help to me and thanks alot in advance.

Are the types of both keys the same? Does the join work if you use another SQL
interface for MS-Access?

kind regards,

Jos

[r035198x]

Hi,

I am a newbie to this forum and I want some help from you.

I want to extract some data using jdbc by connecting to the Ms-Access database. When I tried to extract the data from two tables using a query which involves the "join", I have faced a problem stating that "Type mismatch in expression".

But when I tried to retrieve the data from a single table using a simple query, the code is working fine.

Here I am posting my query:

String qry="select TT.PATENT_SK, TTD.STATE_NAME from TRACKER TT,TRACKER_DICT TTD where TT.KEY=TTD.KEY" ;

where I am joining two tables TRACKER and TRACKER_DICT to retrieve the columns PATENT_SK, STATE_NAME.

Any help in this regard will be appreciated and of great help to me and thanks alot in advance.

Also (if you do decide to respond) what types are your keys?