two Inner join and leftjoin

[pol]

Please let me know the reason for invalid sql
for the folowing sql

SELECT
select (roq_salerep_target.* from
from (roq_salerep_target
Left join roq_salesrep_sales
ON roq_salerep_target.salerep_code = roq_salesrep_sales.salesrepcode
and roq_salerep_target.target_date = roq_salesrep_sales.invdate )
INNER JOIN roq_salesrep ON roq_salerep_target.salerep_code =
roq_salesrep.salerep_code
INNER JOIN roqcustomer ON roq_salerep_target.salerep_code = roqcustomer.rep

With thanks
pol

 

[Roger Carlson]

Take a look at my blog post about Ambiguous Outer Joins:
http://rogersaccessblog.blogspot.com/2008/11/access-101-why-do-i-get-ambiguous-outer.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Join]

Please let me know how to give two inner joins and left join in a query.
Please give an example