View Single Post
  #3  
Old June 4th, 2010, 08:56 PM posted to microsoft.public.access.queries
AccessKay via AccessMonster.com
external usenet poster
 
Posts: 22
Default Forcing an ambiguous outer join

Thanks Ken for your reply. My original SQL is as follows:

SELECT tblTransData.number, tblTransData.Empl, tblTransData.[cost code],
tblTransData.[project alias], tblTransData.[cost category], tblCostCat.TypeID,
tblTransData.Trans_Date, tblTransData.TotHrs, tblCostCode.IndirectLabel
FROM tblCostCode LEFT JOIN (tblCostCat LEFT JOIN tblTransData ON tblCostCat.
CostCatNm = tblTransData.[cost category]) ON tblCostCode.CostCode =
tblTransData.[cost code];


Ken Snell wrote:
How about if you post the original query's SQL where you got the error
message about ambigous joins? Let's see if we can debug that query before we
come to any conclusions about whether you need to combine these two queries
or not.

I tried to add another table to my query with a Left join and I receive a
message that my SQL contains ambiguous joins. It went on to say that I

[quoted text clipped - 28 lines]

This is where I received the missing operator error


--
Message posted via http://www.accessmonster.com