Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

primary key

Former Member
0 Kudos

hi experts,

while joining two tables on ON COND.

in that COND the fields should be primary keys or any fields other than primary key we can mention .

please clear me

5 REPLIES 5

Former Member
0 Kudos

hi,

join should always be on a key field.

Please refer to this link for more info,

http://www.w3schools.com/sql/sql_join.asp

Regards,

Vinodh

Former Member
0 Kudos

Hi,

If your problem is solved, please assign points and close the thread.

Regards,

Vinodh

Former Member
0 Kudos

hi,

Join is always done for the key fields only.

Former Member
0 Kudos

It can be a common feilds also but you cant assure the data integrity so we go for primary key.

BUT YOU CAN USE INNER JOIN ON COMMON FEILD ALSO.

regards,

Prabhu

Former Member
0 Kudos

hi

u join two tables using any common fields..

but if it is a key field then retrievel will be efficient,..

reward if useful