I try to join a standard table with a temporary one :

This is what i tried :

```
with temp1 as (
select * from table T )

select * from temp1, t2.field
left join temp1 t2 on temp1.id1 = t2.id2

```

It doesn't work properly. Any ideas ?

Thank you all.