Welcome Guest. Sign in or Signup

1 Answers

Union All in PS Query

Asked by: 6041 views Query

In some cases, you may be required to do a Union of multiple queries to get the desired output. But, if one of these queries have a Long field, it would not be possible for you to do the Union. In such cases, the easiest way to move forward is to use a Union All. Does PS Query allow you to use Union All? Explain how?

 

Related Questions

1 Answers



  1. candidate on May 12, 2012 Reply

    PS Query doesn’t allow us to have a UNION ALL. One of the methods to do this is to make a view with the UNION ALL and then use a simple query to select from it.

    Another complicated method is to provide the UNION ALL as an expression with the PS Query.

    -3 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question