2. PHPRunner General questions
  3. help with sql.
This topic is locked

help with sql.

 		5/3/2012 11:59:35 AM
PHPRunner General questions
B
 bilboss author

help with sql.

group need 2 different tables.

example
table 1

cod_v / ve /

01/1000

02/500

01/500
table 2
cod_v / wa /

01/500

01/500

01/200

02/100
I need a "group by cod_v" Realize that the sum

cod_v / go / wa

01/1500/1200

02/500/100
to do with a "group by" the results of the sums are erroneous.

use inner join

how I can fix this?
regards
C
 		cgphp 5/3/2012

Please, explain better your requirements. On the SQL tab UNIONS are not supported.
B
 		bilboss author 5/3/2012

UNIONS are not supported

this is held in PHPRunner 6.0,

any way to get the result I want

regards
P
 		procheck 5/3/2012

Although Unions are not supported in the Query Designer, you can still code them manually.
B
 		bilboss author 5/3/2012

which would have to be created to implement the code manually?

I am new to this
greetings and thanks
Sergey Kornilov admin 5/3/2012

The simplest approach is to create a view in your database on the top of Union query. Then use this view as a datasource in PHPRunner.