UNION Not supported in Query Designer

This topic is locked

UNION Not supported in Query Designer	2/16/2014 1:28:25 PM
PHPRunner General questions
F F5447 author Hi All, As per the folloiwng manual, http://xlinesoft.com/phprunner/docs/query_designer.htm, UNION is not supported in PHPRunner. This is actually not really true, as in PHPRunner 6.2, the UNION is work fine (OK and no issue). But, in PHPRunner 7.2, I have a statement of multiple UNIONs, but deleted by the Query Designer. So now, what should I do, any suggestion? Thanks and regards, F5447 (Chin)


	Sergey Kornilov admin 2/16/2014
	PHPRunner may not be able to handle complicated SQL query like this one. You may want to try creating a view in MySQL (assume you use MySQL) on the top of this query and then use this view as a datasource in PHPRunner.