SELECT
  QuickLink.quickLinkID,
  QuickLink.name,
  QuickLink.dateCreated,
  QuickLink.webAddressID,
  QuickLink.openInModalInd,
  WebAddress.webAddress,
  WebAddress.statusCode,
  WebAddress.comments
INTO
  :quickLinkID,
  :name,
  :dateCreated,
  :webAddressID,
  :openInModalInd,
  :webAddress,
  :statusCode,
  :comments 
FROM
  QuickLink,
  WebAddress 
WHERE QuickLink.webAddressID = WebAddress.webAddressID 
  AND WebAddress.statusCode = :statusCode 
ORDER BY QuickLink.dateCreated DESC