topic field selection from differant tables in Application Development and Automation Discussions

field selection from differant tables

Former Member — Wed, 31 Jan 2007 10:23:16 GMT

hello all,

i need to select differant fields from differant tables when i select common fields from both the tables, is it necessary that the common field need to be a primary key in both tables.

thanks in advance

seenu

Re: field selection from differant tables

seshatalpasai_madala — Wed, 31 Jan 2007 10:25:39 GMT

HI,

No its not required that the common field be part of the primary key in both tables only thing is you need to prefix the table name if the field names are same. But if you are using a INNER JOIN then there is no need to select both fields since you know the content of both fields will be same if JOIN is ON these fileds as well.

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala

Re: field selection from differant tables

p291102 — Wed, 31 Jan 2007 10:25:59 GMT

HI,

There is no necessity to the field will be the primary key field in that table.

If the particular field is primary key means u can take the data in very secured way that's all.

Thanks,

Shankar

Re: field selection from differant tables

Former Member — Wed, 31 Jan 2007 10:28:17 GMT

Hi,

You need to check the field name in eeach table the name of the field may be change in table you need to find out the values

or create sap query to check the common fields

or create a view for the same

Regards

Shiva

Re: field selection from differant tables

Former Member — Wed, 31 Jan 2007 11:49:17 GMT

Hi,

There is no need that the fields are primary keys . U can select the fileds from different tables Using INNER JOIN or FOR ALL ENTRIES.

Regards,

Shafi