admin 10/13/2015 | |
There are some complicated SQL queries that PHPRunner may not understand. In cases like this you can create a view in MySQL on the top of this query and use this view as a data source in PHPRunner. |
admin 10/13/2015 | |
One more thing - there are excessive selects in your query. This one should work better: SELECT |
S
|
swanside author 10/14/2015 |
Thanks Sergey. SELECT One more thing - there are excessive selects in your query. This one should work better: SELECT |
admin 10/14/2015 | |
You do not need to use quotes but instead of Labtotals in line 5 of your query you need to use the full expression like IFNULL((SELECT ROUND(sum(Invoice),2) FROM labour WHERE Job_No = job.Job_No), 0) SELECT |
S
|
swanside author 10/15/2015 |
Cheers Sergey, You do not need to use quotes but instead of Labtotals in line 5 of your query you need to use the full expression like IFNULL((SELECT ROUND(sum(Invoice),2) FROM labour WHERE Job_No = job.Job_No), 0) i.e. SELECT |