Left Join primary with 0 in the left

[#1]

Hello,

I have a problem with the left join

Example :

Table A

ID1  ART

60   articleB

100 articleC

...

Table B

ID1  LIBID1

060 TOTO

60   TATA

When I use the left join, the program return 2 rows

LEFT JOIN (Table A)

     Select ID1, LIBID from Table B

60 articleB TOTO ????

60 articleB TATA

Could you help me please ?

[Anonymous]

060 will be interpreted as a numeric value (60) and joined accordingly unless you specify Text().

[#3]

So there is no solution ?

[Anonymous]

Sure, load the ID1 fields as text:

Text(ID1) as ID1

This will separate 60 and 060.

[#5]

The problem is not with the left join but when I import the data.

The table B is an access table, and the field ID1 is in Text exactly like that

Table B

ID1  LIBID1

060 TOTO

60   TATA

when I import the data into Qlikview

SQL SELECT ID1 FROM TableB

I have this result

ID1  LIBID1

060 TOTO

060 TATA

The function Text(ID1) doesn't work with Access

Thank you for your help