topic Re: join condition on 2 table using inner join in Application Development and Automation Discussions

join condition on 2 table using inner join

Former Member — Mon, 18 Aug 2008 15:19:30 GMT

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

Re: join condition on 2 table using inner join

Former Member — Mon, 18 Aug 2008 15:43:35 GMT

Hi Priyanka,

Could you be more clear with your question.

Regards,

Chandra Sekhar

Re: join condition on 2 table using inner join

younes_bouaouad — Mon, 18 Aug 2008 17:41:49 GMT

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.

Re: join condition on 2 table using inner join

former_member770378 — Mon, 18 Aug 2008 19:16:49 GMT

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.

Re: join condition on 2 table using inner join

Former Member — Mon, 18 Aug 2008 19:51:06 GMT

Priyanka,

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

Thanks,

Kartavya

Re: join condition on 2 table using inner join

Former Member — Tue, 19 Aug 2008 04:10:06 GMT

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.

Re: join condition on 2 table using inner join

Former Member — Tue, 19 Aug 2008 04:26:04 GMT

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