Closed stefanosusini closed 4 years ago
Just like this: common.Select().from('table1') .from('table2', 'id2', 'table1', 'id1', 'LEFT').fun('AVG', 'col').build();
"SELECT AVG(t2.col) FROM table1 t1 LEFT JOIN table2 t2 ON t2.id2 = t1.id1"
t2
col
table1
t1
table2
id2
id1
thanks
Ping.
This has been implemented and published in version 0.1.25
0.1.25
Just like this: common.Select().from('table1') .from('table2', 'id2', 'table1', 'id1', 'LEFT').fun('AVG', 'col').build();
"SELECT AVG(
t2
.col
) FROMtable1
t1
LEFT JOINtable2
t2
ONt2
.id2
=t1
.id1
"thanks