T
Tara
Hello,
I have another question about left join & inner join. The below works for
all the fields except [keys] for which I am asked for the value parametres.
I'm sure my problem has to do with misplaced or missing parenthesis', but
can someone please tell where? I have tried several different options, but so
far, nothing has worked.
SELECT Requête10.a, Requête10.cn, Requête10.Subtotal,
IIf(Requête10.a=10,Requête10.b,[Tb.Subtotal]) AS OpenSubtotal, Table2.p,
Table2.p*13 AS Purse, Ap.Purse AS Keys
FROM ((Requête10 LEFT JOIN Requête10 AS Tb ON (Requête10.cn=Tb.cn) AND
(Requête10.a=(Tb.a+10))) INNER JOIN Table2 ON (Requête10.a = Table2.a) AND
(Requête10.cn = Table2.cn)) LEFT JOIN Table2 AS Ap ON (Table2.cn = Ap.cn) AND
(Table2.a = (Ap.a+10));
Tara
I have another question about left join & inner join. The below works for
all the fields except [keys] for which I am asked for the value parametres.
I'm sure my problem has to do with misplaced or missing parenthesis', but
can someone please tell where? I have tried several different options, but so
far, nothing has worked.
SELECT Requête10.a, Requête10.cn, Requête10.Subtotal,
IIf(Requête10.a=10,Requête10.b,[Tb.Subtotal]) AS OpenSubtotal, Table2.p,
Table2.p*13 AS Purse, Ap.Purse AS Keys
FROM ((Requête10 LEFT JOIN Requête10 AS Tb ON (Requête10.cn=Tb.cn) AND
(Requête10.a=(Tb.a+10))) INNER JOIN Table2 ON (Requête10.a = Table2.a) AND
(Requête10.cn = Table2.cn)) LEFT JOIN Table2 AS Ap ON (Table2.cn = Ap.cn) AND
(Table2.a = (Ap.a+10));
Tara