you should write direct strings if you want to use aliases. I mean, you should get the attribute name from the Torque constant and concat alias name and attribute name.
String aliasName = "b1";
String b1brandName = aliasName + Brand.BRAND_NAME.substring(Brand.BRAND_NAME.indexOf("."));
Regards, Kostya
T E Schmitz wrote:
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?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
