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
Post a Comment