How do I write a subquery inside select?
I have this SQL which is doing what I want
The query selection representation for this would be
which also works. But I need a representation in a normal select query. I am trying to wrap my head around this, but it just does not seem to work. So far I got this, but not sure if I am on the right path here. I don't see how I can select from the subquery in
allJobTypesManual
.
Thanks in advance!1 Reply
Nevermind, I think the most simplest solution works for this case.