Skip to Content
0
Former Member
May 12, 2008 at 09:38 AM

Perfomance of select

54 Views

Hi , here i am using inner join for 3 data base tables in below code ,

SELECT crco~objid "Object ID

crco~endda "End date

crco~begda "Start date

cssl~lstar "Activity type

cost~tkg001 "Activity Unit price month01

cost~tkg002 "Activity Unit price month02

cost~tkg003 "Activity Unit price month03

cost~tkg004 "Activity Unit price month04

cost~tkg005 "Activity Unit price month05

cost~tkg006 "Activity Unit price month06

cost~tkg007 "Activity Unit price month07

cost~tkg008 "Activity Unit price month08

cost~tkg009 "Activity Unit price month09

cost~tkg010 "Activity Unit price month10

cost~tkg011 "Activity Unit price month11

cost~tkg012 "Activity Unit price month12

INTO TABLE i_actp

FROM crco INNER JOIN cssl

ON crcokostl EQ csslkostl

INNER JOIN cost

ON csslobjnr EQ costobjnr

WHERE crco~objty EQ c_a.

but for this i am getting some lakhs of records so how can i implement FOR ALL ENTRIES for tis select statement ,

thx for u r help