join condition on 2 table using inner join

[Former Member]

Hi friends plz go through my requirment an provide me a solution.

select A~CARRNAME

B~CARRID

B~CONNID

B~CITYFROM

B~CITYTO

B~DISTANCE

into table IT_flight

from SCARR as A INNERJOIN SPLFI AS B

on A_{CARRIED = B}CARRIED

where A~CARRIED in S_CARRIED.

when giving value in s_carrid (select option ) iam getting the values for that particular carrid.

when i execute without givving any value in S_CARRID iam geting all the values based on the condtion. ie: all the carrids.

but my requiremnt is i want only some 4 particular carrid from those all the carrid which satisfy the condtion.

how can i do that.

how can use where condition.

can any one tell me.

Regards,

priyanka

[Former Member]

Hi Priyanka,

Could you be more clear with your question.

Regards,

Chandra Sekhar

[younes_bouaouad]

Hi,

All you have to do is to put your 4 particular CARRID in the select-option! You've got nothing to change about your query. For that use the arrow at the right of your select-option, you'll get a dialog box where you can specifiy single value, intervals and so on as criteria for your select-option.

[former_member770378]

Try option "UP TO 4 ROWS" if you only want the first records.

Be carefull you must use SELECT ... ENDSELECT to use the option UP TO 4 ROWS

SELECT * FROM table

INTO CORRESPONDING FIELDS OF g_it_table

UP TO 4 ROWS

APPEND g_it_table.

ENDSELECT.

[Former Member]

Priyanka,

There is nothing wrong with the query. It should work. Probably check the option you are provinding on selection screen.

Thanks,

Kartavya

[Former Member]

Hi,

There is no problem with your select query. If you dont want all the carrid, then use a dropdown box with only the required values. So, if u dont give any values it shd select only those 4 carrid values.

Sharin.

[Former Member]

Hi,

On your selection-screen.... select option you have icon to the right most corner... extension..

click on that and in single values... mention the required four carrid's

You need not change your select query

regards

padma