Global select query

[Former Member]

hi,

I have custom table tab1 with fields V1, V2,V3.

V1 v2 are the mandatory fileds.

these V1 V2 are also existing in another table say tab2 along with addtional fields say V4, V5,V6.....etc.

On the basis of V4 How can I fetch V3.

Common fileds in tab1 and tab2 are V1 and V2.

in

Can anybody provide some sample statement for this.

Thanks

[Former Member]

hi,

I have custom table tab1 with fields V1, V2,V3.

V1 v2 are the mandatory fileds.

these V1 V2 are also existing in another table say tab2 along with addtional fields say V4, V5,V6.....etc.

On the basis of V4 How can I fetch V3.

Common fileds in tab1 and tab2 are V1 and V2.

in

Can anybody provide some sample statement for this.

Thanks

[Former Member]

in tab2 V4 is key filed and tab1 V1 and V2 are key fields

I need fetch V3 on the basis of V4.

[Former Member]

since in tab2 V4 is key field and V1 & V2 are not, so for each V4 u can get multiple V1 and V2.

select V1 V2 from tab2 into table t1 where V4 = <some value>

select V3 from tab1 into table t2 for all entries in t1 where V1 = t1.V1 and V2 = t1.V2.

"where t1 is type having only V1 and V2 and t2 will be having only V3,

[Former Member]

Please SEARCH in SCN before posting basic questions.

[Former Member]

Try using the concept of

 FOR ALL ENTRIES