SELECT
  ProviderEnquiry.providerEnquiryID,
  ProviderEnquiry.referenceNumber,
  ProviderEnquiry.name,
  ProviderEnquiry.nameUpper,
  ProviderEnquiry.homeAddressID,
  ProviderEnquiry.workAddressID,
  ProviderEnquiry.homePhoneNumberID,
  ProviderEnquiry.workPhoneNumberID,
  ProviderEnquiry.mobilePhoneNumberID,
  ProviderEnquiry.providerCategoryPeriodID,
  ProviderEnquiry.additionalName,
  ProviderEnquiry.preferredSession,
  ProviderEnquiry.reasonForEnquiry,
  ProviderEnquiry.confirmedMeetingDetails,
  ProviderEnquiry.attendedMeeting,
  ProviderEnquiry.obtainedApplicationForm,
  ProviderEnquiry.scheduledMeeting,
  ProviderEnquiry.noOfChildren,
  ProviderEnquiry.availabilityForContact,
  ProviderEnquiry.additionalInformation,
  ProviderEnquiry.enquiryDate,
  ProviderEnquiry.endDate,
  ProviderEnquiry.ownerName,
  ProviderEnquiry.recordStatus,
  ProviderEnquiry.preferredLanguage,
  ProviderEnquiry.preferredCommunication,
  ProviderEnquiry.versionNo
INTO
  :providerEnquiryID,
  :referenceNumber,
  :name,
  :nameUpper,
  :homeAddressID,
  :workAddressID,
  :homePhoneNumberID,
  :workPhoneNumberID,
  :mobilePhoneNumberID,
  :providerCategoryPeriodID,
  :additionalName,
  :preferredSession,
  :reasonForEnquiry,
  :confirmedMeetingDetails,
  :attendedMeeting,
  :obtainedApplicationForm,
  :scheduledMeeting,
  :noOfChildren,
  :availabilityForContact,
  :additionalInformation,
  :enquiryDate,
  :endDate,
  :ownerName,
  :recordStatus,
  :preferredLanguage,
  :preferredCommunication,
  :versionNo 
FROM
  ProviderEnquiry
WHERE 
enquirydate >=  :startDate 
and enquirydate <= :endDate 
and ownername = :ownerName 
and recordStatus = :recordStatus