I am working on a view that requires data from two different databases on the same server. I am using fully qualified names on the joins, but I am having difficulty in setting them up in a functional manner.
I was hoping someone could take a look at this and show me what I can do to get this to work.
SELECT
wwwstores.dbo.zSTORE.Store_Number,
wwwstores.dbo.zSTORE.Store_Name,
wwwstores.dbo.zSTORE.Street_Address,
wwwstores.dbo.zSTORE.City,
wwwstores.dbo.zSTORE.State,
wwwstores.dbo.zSTORE.Zip_Code,
wwwstores.dbo.zSTORE.Zip_Ext,
wwwstores.dbo.zSTORE.Phone_Number,
wwwstores.dbo.zSTORE.Email_Address,
wwwstores.dbo.zSTORE.Location,
wwwstores.dbo.zSTORE.Latitude,
wwwstores.dbo.zSTORE.Longitude,
wwwstores.dbo.zSTORE.status,
wwwstores.dbo.zSTORE.SM_Name,
wwwstores.dbo.zSTORE.DM_Nmae,
www.stores.dbo.zSTORE.RVP_Name,
wwwstores.dbo.Stores.yearopen,
wwwAdvertising.dbo.StorePaper.Newspaper_ID,
wwwAdvertising.dbo.Store_Paper.Chain,
wwwAdvertising.dbo.Store_Paper.Address_Tag,
wwwAdvertising.dbo.Store_Paper.Ad_Stores,
wwwAdvertising.dbo.Newslist.adsize,
wwwAdvertising.dbo.Newslist.primarycontact,
wwwAdvertising.dbo.Newslist.primaryphone,
wwwAdvertising.dbo.Newslist.primaryemail,
wwwAdvertising.dbo.Newslist.Newspaper,
wwwAdvertising.dbo.Newslist.billing
FROM
wwwstores.dbo.Stores
INNER JOIN wwwstores.dbo.zSTORE
ON wwwstores.dbo.Stores.Store = wwwstores.dbo.zSTORE.Store_Number
wwwAdvertising.dbo.Store_Paper
INNER JOIN wwwStores.dbo.zStore
ON wwwAdvertising.dbo.Store_Paper.Store_Number = wwwStores.dbo.zStore.Store_Number
wwwAdvertising.dbo.Newslist
INNER JOIN wwwStores.dbo.scrapping
ON wwwAdvertising.dbo.Newlist.adgroup = wwwStores.dbo.scrapping.adgroup
ORDER BY
yearopen DESC