blob: 8ad0ef844ccc20334efb7cd849e70f5f742f9566 (
plain) (
blame)
1
2
3
4
5
6
7
|
PRAGMA DisableSimpleColumns;
/* postgres can not */
SELECT A.*, C.subkey as goal,B.*, A.value || C.value as ac_val_concat
FROM plato.A
JOIN plato.B ON A.key == B.key
JOIN plato.C ON B.subkey == C.subkey
ORDER BY A.key, goal, ac_val_concat;
|
