two Inner join and leftjoin

P

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
 
J

Join

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to give two inner joins and left join in a query. Please give an e 1
Inner join and Left Join 1
Inner Join works in MDB but not in ACCDB 0
SQL VBA -- INNER JOIN Syntax 6
Table ALIAS of INNER JOINs ?!?! 2
To give inner join and Left outer Join 3
Only return top 5 records per category 1
HELP WITH Access QUERY PLEASE :) 8

Top