Need help finishing view/query for SQL backend
Posted on 2007-04-10
I am working on a sales database that is needs to be linked into a seperate database on the same server to pull some information. Both are SQL. I have partially created the query i need in a view on the sales db side. But what i need to do now is finish the query so it populates the sales side with the needed info. Or atleast gives me the view to where i can display it (the frontend is access 2003). I have a blank field that has contractID on the sales side. I have a populated field with the contractID in the other database. I also have OPPID that acts as the key on both sides. Can someone help me finish this query
SELECT TimeMatters6.tm6user.matter.mat1_04_09, dbo.Job.OpportunityID, TimeMatters6.tm6user.matter.mat_no
FROM TimeMatters6.tm6user.matter INNER JOIN
dbo.Job ON TimeMatters6.tm6user.matter.mat1_04_09 = dbo.Job.OpportunityID
I need to take the results and be able to view them in the sales database. I'm very new to sql so please be as literal as possible!!