topic Re: primary key in Application Development and Automation Discussions

primary key

Former Member — Thu, 12 Jul 2007 06:39:09 GMT

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 — Thu, 12 Jul 2007 06:48:41 GMT

hi,

join should always be on a key field.

Please refer to this link for more info,

Regards,

Vinodh

Former Member — Wed, 18 Jul 2007 11:01:32 GMT

Hi,

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

Regards,

Vinodh

Former Member — Wed, 18 Jul 2007 11:05:45 GMT

hi,

Join is always done for the key fields only.

Former Member — Wed, 18 Jul 2007 11:06:10 GMT

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 — Wed, 18 Jul 2007 11:16:41 GMT

u join two tables using any common fields..

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

reward if useful