Hi, I'm trying to do a query but somehow can't manage that stupid
access syntax.
While trying I created a query which reproducible crashes access!
What am I doing wrong?:
SELECT p.Problem, p.Problem_lang, l.Loesung, l.Loesung_lang,
h.Hersteller
FROM ((Problem AS p inner join Prob_Loes AS pl on p.ID_Problem =
pl.ID_Problem)
inner join Loesung AS l on pl.ID_Loesung = l.ID_Loesung)
left join Hersteller AS h on p.ID_Problem = h.ID_Problem;
Re: How to use several joins in one query? ..."MIKQ" wrote: ...access syntax.... While trying I created a query which reproducible crashes access! ... FROM ((Problem AS p inner join Prob_Loes AS pl on p.ID_Problem = ... (microsoft.public.access.queries)
Re: Update Query ... (repamount AS ra INNER JOIN checksplit AS c ON ... If so, then, turn the SELECT query into an UPDATE ... > But when I try to translate this query into Access SQL,... > Here is my Access syntax:... (microsoft.public.access.queries)
Re: correlated subquery in the crosstab ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... I have students, courses, exam groups containing exams of courses, ... that the crosstab query in access has much more capablities than ... (microsoft.public.access.queries)
Re: correlated subquery in the crosstab ... I solved my problem using stored queries to act as subqueries.... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... that the crosstab query in access has much more capablities than ... (microsoft.public.access.queries)
Re: correlated subquery in the crosstab ... The first query...TRANSFORM FirstAS FirstOfscore ... FROM tblStudent INNER JOIN (((tblEduYear INNER JOIN tblExamGrp ON ... that the crosstab query in access has much more capablities than ... (microsoft.public.access.queries)
