Select statement queries

[Former Member]

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

[Former Member]

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

[Former Member]

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