U++ forum: Welcome to the forum

Re: SQL to SqlExp [message #22082 is a reply to message #22080]

Tue, 16 June 2009 23:30

mirek
Messages: 14263
Registered: November 2005

Ultimate Member

andrei_natanael wrote on Tue, 16 June 2009 15:23

I've tried to join some tables(multiple times) and i've used something like CITY.Of(CCY).As(CURRENT_CITY) but without success. Actually it works but i have to create aliases for tables and i don't know how to do it with SqlExp

Create SqlIds.

SqlId CURRENT_CITY("CURRENT_CITY");

or

SQLID(CURRENT_CITY); // Same, using macro to duplicate id

CITY.Of(CCY).As(CURRENT_CITY);

Or use them directly

CITY.Of(CCY).As(SqlId("CURRENT_CITY");

Report message to a moderator