Hello, I've started playing with jOOQ for a week now, using it as a sql querybuilder to use with spring's jdbcTemplate, and until now the framework is fullfilling my needs !
I'm now facing the following concern, which I don't know how to achieve, even since I've read the doc and browsed the api javadoc : Let's say I have a countries table : ccode char(2) PK, cname varchar(255) I'd like to produce the following resultset : 'fr', 'fr - France' The generated select statement (mysql syntax) should be like this : <pre> select `t`.`ccode`, concat(cast(`t`.`ccode` as char), ' - ', cast(`t`.`cname` as char)) as `value_` from `countries` as `t` order by `t`.`country` asc </pre> I would like to kow how to programmatically achieve it using the Factory.concat method, or maybe do have I missed something ? Thanks in advance and greetings from France! TL.
