Question: Need a SQL query to perform the requested task on three tables as identified below. Note we do not want to hard code the tables

Need a SQL query to perform the requested task on three tables as identified below. Note we do not want to hard code the tables in our code.

Need a SQL query to perform the requested task on three tables

as identified below. Note we do not want to hard code the

Regarding the ZVSESTL2 tables, thanks. I was able to filter out the related tables needed for this project using this set. I've listed the real estate (RE) and license collector (LC) two tables, as well as the COBOL PROGRAM-ID column, below. This request aims to identify in each COBOL program the union or combination of the two tables RE and LC as well as their frequency in each program. Let me know if you have any questions. Thanks, see the image below and an example. The results from above example tables RE and LC are contained in program CVIABP0. \begin{tabular}{|l|l|l|} \hline Table - RE & Table LC & PROGRAM-ID \\ \hline & & \\ \hline NLXF & ARTN & CVIAAPO \\ \hline SADR & BDAT & CVLIABPO \\ \hline ADXF & CALC & CVLIACPO \\ \hline NGHD & CDAT & CVLIADPO \\ \hline CBLK & DTYP & CVLIBAPO \\ \hline ASMT & FISN & CVLIBCPD \\ \hline PRCL & GBLRATE & CVLIBCPO \\ \hline APPEAL & GBLYEAR & CVLIBDPO \\ \hline BLDGDR & LCPR & CVLIBEPO \\ \hline BLDGDT & LGAL & CVLIBGPO \\ \hline BLDGDN & TRAN & CVLIBHPD \\ \hline BLDGCB & TRDN & CVLIBHPG \\ \hline BLDCP & GBLRATE & CVLIBHPO \\ \hline BLDGCS & DTYP & CVLIBIPD \\ \hline RETRD1 & CDAT & CVLIBIPG \\ \hline RETRPM & CALC & CVLIBIPP \\ \hline RETRS1 & BDAT & CVLIBIPO \\ \hline RETRS2 & ARTN & \\ \hline RETRS3 & & \\ \hline RETRTR & & \\ \hline REAR & & \\ \hline \end{tabular} Regarding the ZVSESTL2 tables, thanks. I was able to filter out the related tables needed for this project using this set. I've listed the real estate (RE) and license collector (LC) two tables, as well as the COBOL PROGRAM-ID column, below. This request aims to identify in each COBOL program the union or combination of the two tables RE and LC as well as their frequency in each program. Let me know if you have any questions. Thanks, see the image below and an example. The results from above example tables RE and LC are contained in program CVIABP0. \begin{tabular}{|l|l|l|} \hline Table - RE & Table LC & PROGRAM-ID \\ \hline & & \\ \hline NLXF & ARTN & CVIAAPO \\ \hline SADR & BDAT & CVLIABPO \\ \hline ADXF & CALC & CVLIACPO \\ \hline NGHD & CDAT & CVLIADPO \\ \hline CBLK & DTYP & CVLIBAPO \\ \hline ASMT & FISN & CVLIBCPD \\ \hline PRCL & GBLRATE & CVLIBCPO \\ \hline APPEAL & GBLYEAR & CVLIBDPO \\ \hline BLDGDR & LCPR & CVLIBEPO \\ \hline BLDGDT & LGAL & CVLIBGPO \\ \hline BLDGDN & TRAN & CVLIBHPD \\ \hline BLDGCB & TRDN & CVLIBHPG \\ \hline BLDCP & GBLRATE & CVLIBHPO \\ \hline BLDGCS & DTYP & CVLIBIPD \\ \hline RETRD1 & CDAT & CVLIBIPG \\ \hline RETRPM & CALC & CVLIBIPP \\ \hline RETRS1 & BDAT & CVLIBIPO \\ \hline RETRS2 & ARTN & \\ \hline RETRS3 & & \\ \hline RETRTR & & \\ \hline REAR & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Botswana has always been one of those countries that has suffered the curse of proximity to South Africa. The proximity to South Africa has led to a lot of reliance on South Africa for almost every...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

that is all that was given In this Task you will build a database to support the needs of The Central Hospital, England who are working with local doctors' surgeries to keep accurate data about the...

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Really having a hard time on this assignment. Details: This assignment serves to benchmark competencies 1.5: Apply knowledge of database architecture and design to meet organizational needs and In...

You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

(a) (b) V = ts B T nin int P P = = (i) Compare stimulated Brillouin and stimulated Raman scattering in optical fibers and indicate the way in which they may be avoided in optical fiber...

Prepare the Statement of Retained Earning for the given information below. No. Items 1 On December 1, Intel Inc. Received 80.000 TL cash from stockholders. 2 On December 5, Intel Inc. Purchased...

What is the price of 1 8 2 - day money market security with face value of $ 7 , 0 0 0 if the bond equivalent yield is 3 . 5 7 4 % ?

What is the Future Value of $ 5 0 , 0 0 0 at the end of 3 years with an interest rate of 5 % ?

3. How can employees and their managers determine whether they are interested and qualified for leadership positions? Source: D. Brady, Secrets of an HR Superstar, Business Week (April 9, 2007)....

6. Go to www.uawford.com, the Web site for the UAW-Ford National Programs Center. Choose one of the joint programs to investigate. Search the Web site to find information about the program. What is...

1. Go to the Web site for Hewlett-Packard (HP) at www.hp.com. Click on About US, and then, click on Diversity Inclusion. Hewlett-Packard is known for its commitment to diversity. How does HP...