DL
как в реляционной бд это сделать я понимаю, а тут нифига не догоняю, конечно реально хочется сделать join все таки а не 2 запроса
как бы вы сделали это в реляционной бд?
SELECT QUESTIONARIES.ID AS "id",
QUESTIONARIES.TITLE AS "title",
QUESTIONARIES.DESCRIPTION AS "description",
QUESTIONARIES.PUBLICATION_DATE AS "publicationDate",
QUESTIONARIES.PLANNED_END_DATE AS "plannedEndDate",
QUESTIONARIES.ACTUAL_END_DATE AS "actualEndDate"
FROM QUESTIONARIES
LEFT JOIN COMPLETED_QUESTIONARIES
ON QUESTIONARIES.ID = COMPLETED_QUESTIONARIES.QUESTIONARY_ID AND COMPLETED_QUESTIONARIES.UKL = #{ukl}
WHERE QUESTIONARIES.STATE = #{state}
AND COMPLETED_QUESTIONARIES.ID IS NULL
ORDER BY QUESTIONARIES.CREATION_DATE DESC
