I am essentially wanting to join the Region table to the Entry table if the column Entry.Category contains Region.Region_Name.
The code I am using is as follows:
select Entry.Category, REGION.REGION_NAME from Entry join REGION on Entry.Category like ('%' + REGION.REGION_NAME + '%')
Any help would be very appreciated!
Best answer by takashi
Hi,
Although the SQL syntax is basically standardized, there also are partial differences depending on database engine. In the InlineQuerier, you have to follow SQLite specification, since the transformer uses SQLite database internally.
Try using || operator to concatenate string, instead of +.
-----
select Entry.Category, REGION.REGION_NAME
from Entry inner join REGION on Entry.Category like ('%' || REGION.REGION_NAME || '%')
-----
Takashi
Hi,
Although the SQL syntax is basically standardized, there also are partial differences depending on database engine. In the InlineQuerier, you have to follow SQLite specification, since the transformer uses SQLite database internally.
Try using || operator to concatenate string, instead of +.
-----
select Entry.Category, REGION.REGION_NAME
from Entry inner join REGION on Entry.Category like ('%' || REGION.REGION_NAME || '%')
-----
Takashi
I totally forgot about that as a possibility!!
Works like a champ now.
-Garrett
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
