I'm struggling with a solution that allows me to dynamically define the
name of a result column. Consider the following:
CREATE TABLE TAB1 (A1,B1);
INSERT INTO TAB1 VALUES('AA1','BB1');
WITH PREFIX(PFX) AS (SELECT 'A')
SELECT (SELECT PFX||'1' FROM PREFIX) FROM TAB1;
What I want to happen here is that the values in column A1 ('AA1' in this
case) be returned but instead I get 'A1' in return.
Is there a way to achieve this?
Staffan
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
