Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I got it working eventually - had the INTO clause in the wrong place, despite trying several guesses

This version of my query worked for me, and also worked without the CACHED keyword.

SELECT "xx"."PK", "xx"."email", "yy"."PK" AS "refbyFK", "xx"."fnam", "xx"."snam", "xx"."dob", "xx"."addr", "xx"."prev", "xx"."comment" INTO CACHED "logins" FROM "pasted_dates" AS "xx", "pasted_dates" AS "yy" WHERE "xx"."recby" = "yy"."email"

I got it working eventually - had the INTO clause in the wrong place, despite trying several guessesguesses.

SELECT ... INTO ... FROM ... WHERE

And each "..." gives relevant parameters for the preceding keyword

This version of my query worked for me, and also worked without the CACHED keyword.

SELECT "xx"."PK", "xx"."email", "yy"."PK" AS "refbyFK", "xx"."fnam", "xx"."snam", "xx"."dob", "xx"."addr", "xx"."prev", "xx"."comment" "xx"."comment"

INTO CACHED "logins" "logins"

FROM "pasted_dates" AS "xx", "pasted_dates" AS "yy" "yy"

WHERE "xx"."recby" = "yy"."email"