primary key

[Former Member]

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

[Former Member]

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]

Hi,

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

Regards,

Vinodh

[Former Member]

hi,

Join is always done for the key fields only.

[Former Member]

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]

hi

u join two tables using any common fields..

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

reward if useful