Query in SELECT statement!!!!

Hi all,

I have a SELECT statement as follows:

SELECT a_{guid_hi b}partner_no

FROM crmd_link AS a

INNER JOIN crmd_partner AS b ON b_{guid EQ a}guid_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