I have the following query CREATE VIEW MyStuff AS SELECT Com . CompanyID CompID , PublicationID PubID , RelationshipDescription Relationship , CompanyName Name , BranchName Branch , BranchID FROM Publication_Branch_Relationships AS PBRel LEFT JOIN ltblPublication_Branch_Relationship AS BRel ON PBRel . RelationshipID = BRel . RelationshipID LEFT JOIN Companies AS Com ON PBrel . CompanyID = Com . CompanyID LEFT JOIN Branches AS Branches ON Branches . CompanyID = Com . CompanyID ORDER BY PublicationID , RelationshipDescription
The rest of the fields i have picked from the other table, now when i try to pick CompanyID it refuses giving an ambiguous field error so i have to select as Com.CompanyID. Now when i issue out a query i.e Select * >From MyStuff Where CompID = 3562; I dont get anything from that result, seems like a bug. But i can query on all the other columns. Can anyone help me out here, i am a bit stuck and this is a very strange error indeed! Regards Roger
