Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Is it possible to have two select statements in a custom view?I have been trying but get errorsCheersPaul
Paul,unfortunately you can't use union on the Edit SQL query tab.I recommend you to create view in the database directly and then use this view in the PHPRunner.