topic Re: SELECT statement in FROM clause - syntax help in Application Development and Automation Discussions

SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 08:58:49 GMT

Hi,

I want to have a SELECT statement in the FROM clause. I get syntax error when doing this and since I am new to ABAP I need som help.

I want to do the following, (and if anyone has any SELECT statement from their own system which you know there is no syntax error in please post it here so I can analyze the syntax):

*I leave the INTO itab clause out, since I only want to demonstrate the functionality

I am trying to get.

SELECT tableOne~someField

FROM tab AS tableOne (SELECT someField

FROM tab

WHERE someFiled > 1) AS tableTwo

WHERE tableOne_{someField > tableTwo}someField

like I said, the problem is that the select statement in the parenthesis in the from clause seems to be incorrect because I get "wrong expression" when trying to compile. Is this because I cannot have a select statement in the from clause or is it because of a minor syntax error, such as I forgot a dot, or some other sign?

thanks and regards

Baran

Re: SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 09:08:12 GMT

I suppose you want to do a join, don't I?

If it's so:

SELECT tableOne_{someField tableTwo}someField

FROM tab AS tableOne A INNER JOIN tab2 AS tableTwo

on tableOne_{someField > tableTwo}someField

INTO TABLE ITAB.

WHERE tableTwo~someFiled > 1.

Where ITAB is an internal table with fields of TAB and TAB2.

Max

Re: SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 09:09:17 GMT

Baron,

Write the staement like below.

data : begin of itab occurs 0,

some field like tableTwo-somefield,

end of itab.

SELECT someField into table itab

FROM tab

WHERE someFiled > 1.

if not itab[] is initial.

SELECT someField

into table itab2

FROM tableOne

for all entries in itab

WHERE someField > itabsomeField.

endif.

Pls. reward if useful

Re: SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 09:11:05 GMT

sorry i am not enough familiar with sub queries but some error i can see which i will state here.

1> you have to use sub queries i.e. select in ( ) after where clause because here you are fulfilling a where clause by another select statement.

like this

SELECT * FROM SFLIGHT

INTO WA

WHERE SEATSOCC = ( SELECT MAX( SEATSOCC ) FROM SFLIGHT ).

2> you cannot specify field name without into clause either you have to use

select * or select f1 into tab-f1 like this...

but if you are using select * without into you have to define

tables : dbtab.

selec * from dbtab. like that.

regards

shiba dutta

Re: SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 09:13:13 GMT

hi,

check this

SELECT p_{carrid p}connid f_{fldate b}bookid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( spfli AS p

INNER JOIN sflight AS f ON p_{carrid = f}carrid AND

p_{connid = f}connid )

INNER JOIN sbook AS b ON b_{carrid = f}carrid AND

b_{connid = f}connid AND

b_{fldate = f}fldate )

WHERE p~cityfrom = 'FRANKFURT' AND

p~cityto = 'NEW YORK' AND

f_{seatsmax > f}seatsocc.

Regards,

Sruthi

Re: SELECT statement in FROM clause - syntax help

Former Member — Thu, 01 Mar 2007 09:20:04 GMT

I guess you cannot use subqueries in FROM claus , u can only use in WHERE condition


REPORT ZTEST.

TABLES :MARA , MAKT , DD02L.

DATA : V_MATNR LIKE MARA-MATNR,
       V_MAKTX LIKE MAKT-MAKTX.



SELECT SINGLE A~MATNR
       B~MAKTX
       FROM MARA AS A INNER JOIN
            MAKT AS B
            ON A~MATNR EQ B~MATNR
            INTO (V_MATNR , V_MAKTX)
            WHERE A~MATNR EQ ( SELECT MAX( SEATSOCC ) FROM SFLIGHT ).