2. PHPRunner General questions
  3. UNION only functions in 'edit query' but not online
This topic is locked

UNION only functions in 'edit query' but not online

 		5/6/2008 12:17:47 PM
PHPRunner General questions
V
 vytb author

In the latest build, the UNION functions normally in 'edit query' results, but online I get no results. What would be the reason? I use UNION for generating reports.
I don't think I had this problem in old builds...
J
 		Jane 5/7/2008

Hi,
unfortunately PHPRunner does not support UNION.

As workaround create view (in the MySQL 5.0 or later) in the database directly and then use this view in the PHPRunner.