I have two queries and would like to join them. One of the queries already has a join so I’m getting confused on the process. At the end I need a complete security report that will show all the main parts. I need to include a specific resource tag and I’m trying to get Subscription rather than the ID, along with resource and resource group.

I have two queries and would like to join them. One of the queries already has a join so I’m getting confused on the process. At the end I need a complete security report that will show all the main parts. I need to include a specific resource tag and I’m trying to get Subscription rather than the ID, along with resource and resource group.

I have two queries and would like to join them. One of the queries already has a join so I’m getting confused on the process. At the end I need a complete security report that will show all the main parts. I need to include a specific resource tag and I’m trying to get Subscription rather than the ID, along with resource and resource group.

I have two queries and would like to join them. One of the queries already has a join so I’m getting confused on the process. At the end I need a complete security report that will show all the main parts. I need to include a specific resource tag and I’m trying to get Subscription rather than the ID, along with resource and resource group.

I have a list of items and I need to split each of the items by a delimiter to convert that to a list.

I have data where I get an activitystatus and I am doing the following:

I have a dataset as below

I would like to check two different tables and then ignore the matched results in the output.
Example: If Table1 with Source1 has the Name “ABC” as well as Number “123” or “456” and at the same time if Table2 with Source1 has Type == “Misc” then ignore the matches and return everything else. thanks

Here I have two columns in the table, the same operation_Id column has 2 or more different language. Need to pick only one operation_Id from the table.