Inner Join with Hex index

[xialie via AccessMonster.com]

Hello!

I am an access novice, can anyone pls help me with this?

I have two tables.
Table A contains UNICODE values (20254 rows of hexadecimal numbers) and other
stuff.
Table B contains 5707 rows of UNICODE values of the same format, ordered
differently.
In both tables, the datatype is TEXT.
I KNOW that ALL the rows in table B have corresponding values in table A.

Now, the following simple query yields only one row (the 5698th row in table
2 and the 17905th in table 1).

SELECT TAB1.*, TAB2.*, TAB1.unicode
FROM TAB1 INNER JOIN TAB2 ON TAB1.unicode = TAB2.unicode;



How do get ALL the results?

Thank you!

 

[Lord Kelvan]

well for one you can remove the tab1.unicode from the select and are
you sure that the values in table b are exatally the same as the
values in table a can you paste a few sample unicodes from table a and
a few of the corresponding ones in table b because that should
therotically work

 

[xialie via AccessMonster.com]

Thank you!

Xialie

well for one you can remove the tab1.unicode from the select and are
you sure that the values in table b are exatally the same as the
values in table a can you paste a few sample unicodes from table a and
a few of the corresponding ones in table b because that should
therotically work