hello,

i have two table :

Table1 : ptl_point_livraison

column a pk, fk
column b pk
column c fk
column d
column e


Table2
column a pk
column c pk
column g


********mapping table1 : Classe PointLivraison

<!-- Cle primaire -->
<composite-id name="ptlPK" class="PointLivraisonPK">
<key-property column="a" name="replique" />
<key-property column="b" name="codePtl" />
</composite-id>
<!-- Champs simples -->
<property column="c" name="codeScl" />
<property column="d" name="codeExpSrc" />
<property column="e" name="codePtlLingerie" />

<many-to-one name="serviceClient" class="ServiceClient" insert="false" update="false">
<column name="a"/>
<column name="c"/>
</many-to-one>

*******mapping table2 : Classe ServiceClient

<composite-id name="sclPK" class="ServiceClientPK">
<key-property name="replique" column="a" />
<key-property name="codeScl" column="c" />
</composite-id>
<property name="liblScl" column="g" />



when i load table1 : i have duplicate column 'a' in sql query :

select pointliv0_.a as a, pointliv0_.b as b, pointliv0_.c as c, pointliv0_.d as d , pointliv0_.e as e, pointliv0_.a as a from ptl_point_livraison pointliv0_ where (......

and is not supported by sybase


how to modify my code for avoid this.

thank you.



Ps : d