join expression not supported???

V

VilMarci

Hi All,

I have a database with linked tables and the following query:

SELECT
tmp_chgclosed.CaseId,
sitesla.SLAlevel,
sitesla.Supported,
producttree.SLA,
producttree.Category,
slalevels.Target1

FROM
tmp_chgclosed
LEFT JOIN sitesla ON
tmp_chgclosed.SiteCode = sitesla.SiteCode
LEFT JOIN producttree ON
tmp_chgclosed.Detail = producttree.Competency AND
tmp_chgclosed.Type = producttree.Product AND
tmp_chgclosed.Category = producttree.ProductType
LEFT JOIN slalevels ON
producttree.Category = slalevels.CAT AND
sitesla.SLAlevel = slalevels.SLAtype


Nothing special. The query is working in the query browser, but not in
Access.
The first error was that Access wass missing a few ()'s, that I did not
understand, but ok.
Finally I could do this, when the next error occured:

SELECT *
FROM
((
tmp_chgclosed
LEFT JOIN sitesla ON
tmp_chgclosed.SiteCode = sitesla.SiteCode
)
LEFT JOIN producttree ON
(tmp_chgclosed.Detail = producttree.Competency) AND
(tmp_chgclosed.Type = producttree.Product) AND
(tmp_chgclosed.Category = producttree.ProductType)
)
LEFT JOIN slalevels ON
(producttree.Category = slalevels.CAT) AND
(sitesla.SLAlevel = slalevels.SLAtype)

And getting error message, that Join expression is not supported. Please
advise. The original query is working in any sql browser...
Thanks,
Marton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Join not Supported 1
Join expression not supported with outer joins 5
Forcing an ambiguous outer join 5
acc 2007: help with multiple table outer join syntax 2
Help with 'Join expression not supported' 8
Nested JOIN clauses - order of precedence (Access 2007) 2
Multiple join types in one query, jet compatible, exec from Excel/ 3
Left Join query not working in Access 2010 0

Top