Nested append subqueries

Hi Daniel,

Thanks for reaching out. There is no way to nest Append subqueries.

As you can see when you are configuring the subqueries, you are explicitly configuring the relationship between the Master query and the Subquery:

I suspect it likely that there would be another way to accomplish something similar to this via some other alternative possibility. The issue though, is that this would require Consulting assistance.

Ultimately, I think what we have to consider is what this SQL query would look like, keeping in mind all reports are built based on SQL. Do you have an example of a SQL query that would return two rows, one where there's only one value in one column, while it excludes the other columns? I'm struggling to find an example of a SQL query that could give you a result that looks like this:

Inc numberStatusLast DateLog

INC001

INC002Special2/8/2021Info 17

I've so far been unable to draft a query that returns a result that looks like this.

Thanks,

Mike

Hi Daniel,

I just wanted to check in and see how things are going with this.

Regards,

Mike

Thanks for the info feel free to conclude this post, Thanks =)

Hi Daniel,

Great! Thanks for your response. Will do.

Please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike