Newbie - Needs Help with DTS multiple datasources

How do I use a view or query that references two different data sources ie 1 Oracle (APPPCT_PROJECT_TYPE ) and 1 table within my Sql. (ProjectTypes)



I want to use a query that looks and the data in the Oracle table compares it against my current table to determine if there are differenes and if so update current table with the differences in the data.



This is the query I would have used in Access: Help me to convert it use using DTS.



INSERT INTO ProjectTypes ( ProjectTypeCode, ProjectTypeDescrip, ProjectCatagory, ProjectClass, CapitalProjectNum, DateCreated, UserCreated, DateModified, UserModified )



SELECT APPPCT_PROJECT_TYPE.ID, APPPCT_PROJECT_TYPE.DESCR, APPPCT_PROJECT_TYPE.PROJ_DESCR_CATEGORY, APPPCT_PROJECT_TYPE.PROJ_CLASS, APPPCT_PROJECT_TYPE.CPN, Now() AS Expr1, "import" AS Expr2, Now() AS Expr3, "import" AS Expr4



FROM APPPCT_PROJECT_TYPE LEFT JOIN ProjectTypes ON APPPCT_PROJECT_TYPE.ID = ProjectTypes.ProjectTypeCode



WHERE (((ProjectTypes.ProjectTypeCode) Is Null));



Any assistance in this mater is greatly appreciated.



Sincerely,

Karen