query + access database
-
SELECT distinct u.domain,u.username, count(d.downloadid) as DocumentCount FROM primaryusertable AS u inner join tbluseraccessinfo a on(u.userid=a.userid and a.courntryid=51 ) right join download d on(u.userid = d.userid and CDate( d.downloadutctime) <now()) group by u.username, u.domain it is not working giving syntax error. i could not use inner and right join together in access database
-
SELECT distinct u.domain,u.username, count(d.downloadid) as DocumentCount FROM primaryusertable AS u inner join tbluseraccessinfo a on(u.userid=a.userid and a.courntryid=51 ) right join download d on(u.userid = d.userid and CDate( d.downloadutctime) <now()) group by u.username, u.domain it is not working giving syntax error. i could not use inner and right join together in access database
Do you need a space between your on and your bracket?