doSelectAllExcept... reference the same table twice

[T E Schmitz]

Hello,

I have a table which references the same table twice. In SQL, I would 
express the SELECT (inner join) using an alias :

SELECT
SECTION.SECTION_PK,
SECTION.SECTION_NAME,
SECTION.BRAND_1_FK,
SECTION.BRAND_2_FK,
b1.BRAND_PK,
b1.BRAND_NAME,
b2.BRAND_PK,
b2.BRAND_NAME
FROM SECTION, BRAND  as b1,BRAND  as b2
where b1.BRAND_PK = BRAND_1_FK and
b2.BRAND_PK = BRAND_2_FK
Torque, however, will generate
BRAND.BRAND_PK,
BRAND.BRAND_NAME
as the columns are static variables fully qualified by the tableir name.
Has anyone found a work-around?
--
Regards,

Tarlika Elisabeth Schmitz

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