topic Re: Select statement queries in Application Development and Automation Discussions

Select statement queries

Former Member — Wed, 09 Apr 2008 15:39:29 GMT

Hi all

I want to extract data from three fields. among these three fields, two fields are from standard table and one is from ztable and how can i put it select statement.

Plz tell

Regards

Mona

Re: Select statement queries

Former Member — Wed, 09 Apr 2008 15:44:39 GMT

with a join using the key fields your standard table and your ztable have in common

Re: Select statement queries

Former Member — Wed, 09 Apr 2008 15:44:58 GMT

hi,

use innerjoin...

Select a_{field1 a}field2 b~field into table itab from dbtable as a innerjoin ztable as b on dbtable-field = ztable-field.

Regards

SYed A