Hi All,
I'm trying to wrap my head around the syntax for Access SQL. I'm pretty sure this would normally work, I've previously only dabbled with Oracle. I read something about parentheses with Access joins but the placement of them evades me. Any help would be much appreciated.
I'm trying to wrap my head around the syntax for Access SQL. I'm pretty sure this would normally work, I've previously only dabbled with Oracle. I read something about parentheses with Access joins but the placement of them evades me. Any help would be much appreciated.
Code:
SELECT cu.CustName, v.Date,v.Rate,v1.Date,v1.Rate</SPAN></SPAN>
FROM Value v </SPAN></SPAN>
INNER JOIN Value v1 </SPAN></SPAN>
ON v1.ID = v.ID</SPAN></SPAN>
INNER JOIN Class c </SPAN></SPAN>
ON c.ID = v.ID </SPAN></SPAN>
INNER JOIN Subject s </SPAN></SPAN>
ON s.Sub = c.Sub </SPAN></SPAN>
INNER JOIN Customers cu </SPAN></SPAN>
ON cu.CustNumber = s.CustNumber</SPAN></SPAN>
WHERE v.date = #02/04/2013# and v1.date = #28/03/2013# and cu.custnumber = 19;</SPAN></SPAN>