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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
