[Gvsig_english] Access table and join

[Olivier Bedel]

Hi Hugues,

I have just tested your example with CSV files and the join wizard. It 
works well with my gvSIG (v 1.0 / Linux). I could not test with Access 
tables to help you more...
Best regards,
Olivier.

Olivier Ertz wrote:

> Hi Hugues,
> I understand well your problem, and the join should work properly. 
> But, how did you get this strange join result ? Do you use the join 
> wizard of gvSIG or did you write you own application ? Please give 
> more details on what you do for creating the join.
> A+, Olivier.
>
>
>
> Hugues Boussard a écrit :
>
>> Hi,
>>  
>> The problem is concerning the join option between two "Access" table 
>> with the relation "many to 1".
>>  
>> table 1 :
>> id_1         text_1
>> 1             one
>> 2             two
>>  
>> table 2 :
>> id_2        text_2        id_1
>> 1            t_1             1
>> 2            t_2             1
>> 3            t_3             1
>> 4            t_4             2
>>  
>> I would like to join tables in order to get :
>> table 2 :
>> id_2       text_2        id_1      link_text_1
>> 1           t_1             1          one
>> 2           t_2             1          one
>> 3           t_3             1          one
>> 4           t_4             2          two
>>  
>>  
>> but the bug report me the following table :
>> table 2 :
>> id_2       text_2        id_1      link_id_2      link_text_2
>> 1           t_1             1          1                 t_1
>> 2           t_2             1          2                 t_2
>> 3           t_3             1          3                 t_3 
>> 4           t_4             2          4                 t_4
>>  
>> The problem is the same when I try to join a dbf file to an Access 
>> table.
>> but I managed the join between an Access file to a dbf file and 
>> between two dbf file.
>>  
>> I hope it's clear...
>>  
>> best regards,
>> Hugues B.  
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Gvsig_internacional mailing list
>> Gvsig_internacional at runas.cap.gva.es
>> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>   
>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>