List of Contributions

Contact Details

Ohio State University-Main Campus

Ribbons

Badges

Mr. Aaron Minnick

Ohio State University-Main Campus

Contributions

1 to 2 of 2 total

RE: Use subquery in FROM clause?

Posted By Aaron Minnick 12-19-2025 08:35 AM
Found In Egroup: PS Query & SQL \ view thread
I'll decline to post the actual query for a few reasons. Our DBA's already reviewed it, and their solution was to put the wrapper around it I described. It calls a custom view which actually is causing the Cartesian join and we worked around that specific issue by using a delivered table. We mostly wanted ...

Use subquery in FROM clause?

Posted By Aaron Minnick 12-18-2025 03:41 PM
Found In Egroup: PS Query & SQL \ view thread
I think I have my answer based on a few old threads (they all say it can't be done), but wanted to confirm. Has anyone successfully used expressions to embed a subquery in a SQL FROM clause in PSQuery? We are trying to problem-solve an issue with an inadvertent Cartesian join in a longstanding query. ...