If I use Criteria to do a join between two tables,
what is the standard mechanism to differentiate
between columns of same name and different tables?
For example:

        Criteria ct = new Criteria();
        ct.addSelectColumn(TonePeer.COLX);
        ct.addSelectColumn(TtwoPeer.COLX);
        ct.add(TonePeer.COLY, valueY);
        ct.add(TtwoPeer.COLZ, valueZ);
        ct.addJoin(TonePeer.COLP, TtwoPeer.COLP);
        ct.addJoin(TonePeer.COLQ, TtwoPeer.COLQ);
        Vector v = TonePeer.doSelect(ct);

In this example, the values for COLX in each table are
different.

How do I ask for COLX in Tone, or COLX in Ttwo, from v?
In fact, what exactly is the type of each object that
gets placed in Vector v Are they Tone objects? Also,
is it any different if I do

        Vector v = TtwoPeer.doSelect(ct);

In this case, the type of each object in Vector v would
be Ttwo? And if this is the case, how would I get the
values for all of Tone's columns placed in the select?

Thanks,


-- 
Gonzalo A. Diethelm
[EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to