Database SQL Operation: AdviceItemCaseLink.searchByCaseAndAdviceCategory
Description: | |
Sterotype: | nsmulti |
SELECT
AdviceItemCaseLink.adviceItemCaseLinkID,
AdviceItemCaseLink.adviceItemID,
AdviceItemCaseLink.caseID,
AdviceItemCaseLink.evidenceType,
AdviceItemCaseLink.relatedID
INTO
:adviceItemCaseLinkID,
:adviceItemID,
:caseID,
:evidenceType,
:relatedID
FROM
AdviceItemCaseLink,
AdviceItem
WHERE AdviceItemCaseLink.caseID = :caseID
AND AdviceItemCaseLink.adviceItemID = AdviceItem.adviceItemID
AND AdviceItem.categoryType = :categoryType
|