VERIFIED SOLUTION i
X

How to find SQL to Select/Compare Status on an Enquiry Screen with Status on the Status Log in Confirm

UPDATED: September 26, 2017


The following SQL can be used to to select/compare the Status on an Enquiry with the corresponding Status on that Enquiry's Status Log:

SELECT 
central_enquiry.enquiry_number, 
central_enquiry.enquiry_log_number, 
enquiry_status_log.enquiry_log_number, 
central_enquiry.enq_status_code, 
enquiry_status_log.enq_status_code 
FROM 
central_enquiry, 
enquiry_status_log 
WHERE 
central_enquiry.enquiry_number = enquiry_status_log.enquiry_number AND 
central_enquiry.enquiry_number = <MyEnquiryNumber> 
ORDER BY 
enquiry_status_log.enquiry_log_number; 

Environment Details

Product Feature: Customer Services

Downloads

  • No Downloads