topic Re: select statement for primary keys in Application Development and Automation Discussions

select statement for primary keys

Former Member — Sat, 09 Feb 2008 10:07:51 GMT

What is the syntax to select a statement from a table with only primary keys. there are 4 primary keys i have to select all the 4 primary keys is there any syntax difference???

Re: select statement for primary keys

Former Member — Sat, 09 Feb 2008 10:10:05 GMT

data: itab like ztable.

select * from ztable into corresponding fields of table itab.

can i use like this???

Can i declare my internal table like this where i have to get all the fields in that particular table

Regards

Nanda

Re: select statement for primary keys

Former Member — Sat, 09 Feb 2008 10:16:09 GMT

Hi gurus

just me any suggestion

Re: select statement for primary keys

Former Member — Sat, 09 Feb 2008 10:22:23 GMT

Hi,

u can do like this.........

select <field1 name> 
       <field2 name>
       <fields name>
       <field4 name>
from   <ztable> 
into   corresponding fields of table itab
where  cond.....

Cheers,

jose.

Re: select statement for primary keys

Former Member — Sat, 09 Feb 2008 10:40:39 GMT

Hi,

do u want those primary keys in the internal table or else will u have a where condition based on those all the primary key fields

if u use all the four primary keys u can write like this remember one thing first u write the field just like in the table created order it is not mandatory to do like that but it increases the performance of the so query

select single * from ztable into table t_tab where (mention all the four primary keys here ) it increases the performance we are using this single because u r giving all the primary keys in the select query so obvously one record will be there so it increases the query performance..

if wont give those primary keys then write like this select * from ztable into table t_tab.

as normal as ordinary

i hope u got cleared

plzz reward if it is helpful..

plzz dont forget to reward...