topic Re: Global select query in Application Development and Automation Discussions

Global select query

Former Member — Sat, 19 Sep 2009 12:20:02 GMT

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.

Can anybody provide some sample statement for this.

Thanks

Re: Global select query

Former Member — Sat, 19 Sep 2009 12:24:52 GMT

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

I need fetch V3 on the basis of V4.

Re: Global select query

Former Member — Sat, 19 Sep 2009 12:49:37 GMT

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,

Re: Global select query

Former Member — Sat, 19 Sep 2009 16:01:04 GMT

Please SEARCH in SCN before posting basic questions.

Re: Global select query

Former Member — Sat, 19 Sep 2009 19:16:23 GMT

Try using the concept of

 FOR ALL ENTRIES