banshee wrote:I have problems with it though. One the one hand I can use substring in the columns section only and on the other hand substring(lookup_from_id(id_flop1, 'card_rank') from 2 for 1) is not a valid SQL statement :(
You cannot use the lookup_from_id function in the columns. It's not valid SQL, so it can only be used in the variables and the stat expressions.
