Join!
Hej eksperter!Jeg har følgende statement i min stored procedure på MS Sql 7.0:
SELECT CompanyCriteria.*, Country.Country, CompanyForm.CompanyForm, CompanyType.CompanyType, Area.AreaName, Continent.Continent, OecdClass.Classification
from CompanyCriteria
inner Join Continent on CompanyCriteria.Continent=Continent.ContinentCode
inner Join Country on CompanyCriteria.Country=Country.Code
inner Join CompanyForm on CompanyCriteria.CompanyForm=CompanyForm.id
inner Join CompanyType on CompanyCriteria.CompanyType=CompanyType.id
inner Join Area on CompanyCriteria.Area=Area.AreaCode
inner Join OecdClass on CompanyCriteria.OecdClassification=OecdClass.id
where id=@temp
GO
Men den siger: "Ambiguous Column Name ID"
Hvad betyder dette? Er der en syntaktisk fejl i mit statement?
På forhånd tak!
