Need help on SQL query

[karthik_narayan2]

Hi ,

I am trying to pull the data from 2 tables TBCTO and TBTCP using Inner join condition, but i am not able to get the result.

can anyone please help me out. below is the query.

SELECT tbtco_{jobname tbtco}strttime tbtco_{prdmins tbtco}prdhours

tbtco_{prddays tbtco}prdweeks tbtco_{prdmonths tbtco}periodic

tbtco~eventid

tbtcp_{progname tbtcp}variant

INTO CORRESPONDING FIELDS OF TABLE git_jblst

FROM tbtco

INNER JOIN tbtcp

ON tbtco_{jobname = tbtcp}jobname

AND tbtco_{jobcount = tbtcp}jobcount

WHERE tbtco~jobname LIKE s_jbname.

Thanks,

KN

[Former Member]

Hi,

Try to change your where clause to:

WHERE tbtco~jobname IN s_jbname. "instead of LIKE as yours

regards,

[karthik_narayan2]

Thanks, it works.

[Former Member]

Please check parameter s_jbname, IN ABAP OPEN SQL,Wildcard characters can be used to create the pattern in dobj, where "%" represents any character string, even an empty one, and "_" represents any character. Captilatization is taken into account. Blank characters at the end of dobj are ignored. This is also valid in particular for data objects of the type string with closing blank characters that are otherwise taken into account in ABAP.

You can refer to the following code:

PARAMETERS srch_str TYPE c LENGTH 20.

DATA text_tab TYPE TABLE OF doktl.

CONCATENATE '%' srch_str '%' INTO srch_str.

SELECT *

FROM doktl

INTO TABLE text_tab

WHERE doktext LIKE srch_str.

Edited by: Jack Wu on Sep 17, 2010 11:36 AM