Skip to Content
0
Former Member
May 19, 2008 at 02:14 PM

Query in SELECT statement!!!!

9 Views

Hi all,

I have a SELECT statement as follows:

SELECT aguid_hi bpartner_no

FROM crmd_link AS a

INNER JOIN crmd_partner AS b ON bguid EQ aguid_set

INTO TABLE p_partners

FOR ALL ENTRIES IN i_sub_contracts

WHERE a~guid_hi EQ i_sub_contracts-guid

AND a~objtype_hi EQ '05'

AND b~partner_fct EQ p_partner_fct.

Please tell me if I can create a view for the above.

Once I create a view for the above will it really boost the performance.

Kindly reply immediately as this is bit urgent.

Regards,

Vijay