Hope all is well. I am hoping you can help me.
Problem Statement – I’m tasked to create a dynamic SQL statement which will select all related data from a given table where the Identifier is passed. For each table where the relevant data is found i would like the data to be exported onto a separate tab of within excel
If i was doing this manually done this i would perform the following queries and export the data onto each tab;
Select * from Mason where id = 12345 Select * from MasonContacts where Companyid= 12345 Select * from MasonOpportunities where Comid = 12345
However given the sheer volume of tables this isn’t viable.
Step 1 : Type in my identifier (in this case my identifier is a field called “Id” in the Table “Mason”) The query will always start from this table.
Table Name : Mason
Field : Id = “12345”
Step 2 : Search against table “MasonContacts”, search against the field “Companyid”. Return all columns & records where the field “Companyid = 12345”
Table Name : MasonContacts
Field : Companyid
Step 3 : Search against table “Mason Opportunities “, search against the field “Comid”. Return all columns & records where the field “Company = 12345”
Table Name : MasonOpportunities
Field : Comid
Looking forward to your help