T
Tara
Hello,
I need to do two different LEFT JOIN in one query, but cannot figure out how
to write it out. I have tried the following, but keep getting a syntax
error...
SELECT Table1.a, Table1.cn, IIF((Tb.[c]-Lp.[d])<20, Table1.[d]+50, 0) AS Exp1
FROM Table1 LEFT JOIN Table1 AS Tb ON Table1.a=(Tb.a+20)
FROM Table1 RIGHT JOIN Table1 AS Lp ON Table1.a=(Lp.a+10)
WHERE Table1.cn=Tb.cn
Can someone please help me out?
Tara.
I need to do two different LEFT JOIN in one query, but cannot figure out how
to write it out. I have tried the following, but keep getting a syntax
error...
SELECT Table1.a, Table1.cn, IIF((Tb.[c]-Lp.[d])<20, Table1.[d]+50, 0) AS Exp1
FROM Table1 LEFT JOIN Table1 AS Tb ON Table1.a=(Tb.a+20)
FROM Table1 RIGHT JOIN Table1 AS Lp ON Table1.a=(Lp.a+10)
WHERE Table1.cn=Tb.cn
Can someone please help me out?
Tara.