SELECT
QuickLinkApplicationLink.quickLinkApplicationLinkID,
QuickLinkApplicationLink.quickLinkID,
QuickLinkApplicationLink.applicationCode,
QuickLinkApplicationLink.dateCreated,
QuickLinkApplicationLink.sortOrder,
QuickLink.name,
QuickLink.webAddressID,
QuickLink.openInModalInd,
WebAddress.webAddress
INTO
:quickLinkApplicationLinkID,
:quickLinkID,
:applicationCode,
:dateCreated,
:sortOrder,
:name,
:webAddressID,
:openInModalInd,
:webAddress
FROM
QuickLinkApplicationLink,
QuickLink,
WebAddress
WHERE QuickLinkApplicationLink.applicationCode = :applicationCode
AND QuickLinkApplicationLink.quickLinkID = QuickLink.quickLinkID
AND QuickLink.webAddressID = WebAddress.webAddressID
ORDER BY QuickLinkApplicationLink.sortOrder
|