SELECT
QuickLinkSecurityRoleLink.quickLinkSecurityRoleLinkID,
QuickLinkSecurityRoleLink.quickLinkID,
QuickLinkSecurityRoleLink.roleName,
QuickLinkSecurityRoleLink.dateCreated,
QuickLink.name,
QuickLink.webAddressID,
QuickLink.openInModalInd,
WebAddress.webAddress
INTO
:quickLinkSecurityRoleLinkID,
:quickLinkID,
:roleName,
:dateCreated,
:name,
:webAddressID,
:openInModalInd,
:webAddress
FROM
QuickLinkSecurityRoleLink,
QuickLink,
WebAddress
WHERE QuickLinkSecurityRoleLink.roleName = :roleName
AND QuickLinkSecurityRoleLink.quickLinkID = QuickLink.quickLinkID
AND QuickLink.webAddressID = WebAddress.webAddressID
|