topic Re: sql statement help in Application Development and Automation Discussions

sql statement help

Former Member — Thu, 15 Nov 2007 08:09:59 GMT

what is correct way to write the sql statement in abap way. My sql statement is below:

select name from studenttable s , admintable a

where s.admino = a.admino

this sql using 2 tables which is studenttable and admintable. how to write this sql statement in abap sql.

any help?

Re: sql statement help

former_member386202 — Thu, 15 Nov 2007 08:13:56 GMT

Hi,

Select studenttable~s

admintable~a

into table itab

from studenttable as studenttable

inner join on admintable as admintable

where studenttable_{s = admintable}a.

Reward Points if helpfull

Regards,

Prashant

Message was edited by:

Prashant Patil

Re: sql statement help

Former Member — Thu, 15 Nov 2007 08:15:20 GMT

SELECT s~name

into w_name " declare DATA: w_name(40) type c.

from studenttable as s JOIN admintable as a

on s_{admino = a}admino.

Message was edited by:

Jyothi

Re: sql statement help

Former Member — Thu, 15 Nov 2007 08:15:37 GMT

Hi Gary,

do like this

Select name a_{student b}f1 from student as a innerjoin admin as b into table itab

where a_{student-studentno = b}admin-studentno.

Regards,

Satish

Re: sql statement help

Former Member — Thu, 15 Nov 2007 08:18:06 GMT

data : begin of itab occurs 0,

vname(40),

end of itab.

select s~name into table itab

from student as s inner join

admintable as a

on s_{admino = a}admino.

regards

shiba dutta

Re: sql statement help

Former Member — Thu, 15 Nov 2007 08:22:24 GMT

select name from studenttable s , admintable a

where s.admino = a.admino

this can be writen in ABAP in 2 ways

by useing JOINS and FOR ALL ENTRIES

select name from s into table itab where adminum = condition

select name from a into table itab2 for all entries in itab where s-name = itab1-name,

select s~name a~name from s inner join a
where condition

Re: sql statement help

Former Member — Thu, 15 Nov 2007 08:26:20 GMT

data: it_student type table of studenttable.

SELECT s~studenttable

INTO CORRESPONDING FIELDS OF TABLE it_student

FROM ( studenttable AS s

INNER JOIN admintable AS a ON s_{adminno = a}adminno).