Consider the following setup: CREATE TABLE NAMES(Id integer PRIMARY KEY, Name text); INSERT INTO NAMES VALUES(1,’Tom’); INSERT INTO NAMES VALUES(2,’Lucy’); INSERT INTO NAMES VALUES(3,’Frank’); CREATE TABLE fields(fid integer, fname text); INSERT into fields values(1, “Id”); insert into fields values(2, “Name”); SELECT name, (SELECT “Name”) FROM NAMES; The last statement will output Tom|Tom Lucy|Lucy Frank|Frank However,Read more