To retrive data in two tables

[gsureshraja]

Hello ...
I have one doubt in oracle.

How to get all the data in two tables where each table has diff primary key.
please send the qurey...

thanks


Gsr

[rushdishams]

well, you don't need to have same primary key for 2 tables to get all the data. you need at least one common field/ column to retrieve all data (of course that are relevant) and the field/ column must be in the same domain and data type.

maybe i am mistaking on your post... it was not vivid that much...sorry if that does not help you...

[Sandya]

Hello ...
I have one doubt in oracle.

How to get all the data in two tables where each table has diff primary key.
please send the qurey...

thanks


Gsr

u can find the common field in the two table and use join to fetch the data from two table