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