Re: thank you

   Hi,
        why do  you connect one table with the other? They are't any
relations between them. So I don't understand your point, I am somewhat
confused, you can refer to the following site:
http://www.postgresql.org/docs/9.0/static/queries-table-expressions.html
        http://my.oschina.net/Kenyon/blog/79543
> Ya i got the answer here is the code
>
>
> SELECT *
> FROM (SELECT row_number() over(), * FROM employee) t1
> right outer JOIN (SELECT row_number() over(), * FROM managers) t2 on
> t1.row_number=t2.row_number
>
>
>
> Thank you
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954p5767787.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>