I need to transpose the data from a couple tables (tblOrgHours,tblOrgActivit
ies) to one of the other existing tables (tblOrgEvents. I have events that are in tblOrgHours innerjoin tblOrgActivities that can be located using the following SQL Query.
select * from tblOrgHours H innerjoin tblOrgActivities A on H.ActivityID = A.ActivityID where H.Unregistered > 0
I need the following columns of this recordset to be inserted into tblOrgEvents:
H.Agency, H.ActivityDate, H.Classification,H.BasedOn
, H.HourTimeFrom, H.HourTimeTo, H.Hours, H.Duration, H.Frequency, H.ActivityType, H.ActivityOther, H.Objectives, H.Strategy, H.Need, H.NeedOther, H.Outcome, A.ActivityName, H.Narrative, H.EntryTime, H.Fiscal, H.Unregistered
Some column names are different in the destination table. Please note below:
s) corresponds to EventDate(tblOrgEvents)
H.Narrative(tblOrgHours) corresponds to Comments(tblOrgEvents)
) corresponds to TotalParticipants(tblOrgEv
ities) corresponds to Activity(tblOrgEvents)
Thank you for your help!!