Oracle ODBC funny queries

[Rohan via AccessMonster.com]

I have two queries.

Here is the query that doesn't work:

SELECT commodity1.commodity, ExplorationCommodity.commodityID,
ExplorationCommodity.site_code
FROM SRA_SITE INNER JOIN (commodity1 INNER JOIN ExplorationCommodity ON
commodity1.commodityID = ExplorationCommodity.commodityID) ON SRA_SITE.
SITE_CODE = ExplorationCommodity.site_code
ORDER BY commodity1.commodity;

Here is the query that does work:

SELECT commodity1.commodity, ExplorationCommodity.commodityID,
ExplorationCommodity.site_code
FROM commodity1 INNER JOIN ExplorationCommodity ON commodity1.commodityID =
ExplorationCommodity.commodityID
ORDER BY commodity1.commodity;

There is an entry in SRA_SITE.SITE_CODE called "AMM"
and and entry in ExplorationCommodity.site_code called "amm"

It doesn't find the record in query 1, but does in query 2.

SRA_SITE is an Oracle ODBC table, ExplorationCommodity is an access table.

BOTH QUERIES WORK IF YOU IMPORT SRA_SITE.

Any clues ?

Rohan

 

[Michel Walsh]

Hi,


"maybe" Oracle server is set to differentiate lower and upper case... is
it?


Vanderghast, Access MVP

 

[Michel Walsh]

Hi,


Another possibility is that Oracle field is padded with blank (that may
occur if the data type is a fixed length character type, rather than a
variable characters length type).


Vanderghast, Access MVP

Hi,


"maybe" Oracle server is set to differentiate lower and upper case... is
it?


Vanderghast, Access MVP