sql - How to join select with itself in postgresql? -


how join select in postgresql?

select * (     select  src, dst records ) t1 join t1 t2 using(src) 

update:

my table doesn't exists , create table "select" , want join selected table itself.

use common table expressiom:

with t1 (     select  src, dst records )  select * t1 join t1 t2 using(src) 

Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -