select statement on two tables

[Former Member]

Hi Experts,

I'm working on HTTP to JDBC synchronous interface.JDBC is the receiver side.

I need to fetch data from two tables based on certain conditions, please help me out in getting an approach for this interface?

Thanks,

Pravin.

[Former Member · Accepted solution]

Pravin,

Refer to the url for Performing SQL Joins in XI … (for newbies) https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]

Regards,

Mike

[Former Member]

Hi,

If JDBC is at the receiver side from where you need to fetch the data(Two tables). Can you elaborate ur requirement briefly.

Regards,

Jayaram...

[Former Member]

Hi Jayarama,

I have this following select Query

SELECT count(*)

from kss_activity_stg kas, kss_consumer_hdr kca WHERE

kas.customer_status_flg='A' AND

kas.partner_type='2' AND

kas.segment_type_cd='BLDR' AND

kca.property_name ='CHELDAN HOMES'

based upon the above select query, i need to do a HTTP to JDBC synchronous interface.