access语句和sql 的join 用法有什么不同，大神给讲解一下呗

[Csp_0613]

select T_customer.customer_No,customer_Name,relate_Name,relate_Mobile,
T_messent.id,messent_MessageText,messent_Way,messent_DateTime,T_messent.user_Name 
from T_customer join T_relate on 
T_customer.customer_No=T_relate.customer_No  
right join T_messent on T_relate.relate_Mobile=T_messent.messent_TelNumber

sql语句 怎么改成access版的

[Csp_0613]

select T_customer.customer_No,customer_Name,relate_Name,relate_Mobile,
T_messent.id,messent_MessageText,
messent_Way,messent_DateTime,T_messent.user_Name from
 T_customer join T_relate onT_customer.customer_No=T_relate.customer_No
 right join T_messent on T_relate.relate_Mobile=T_messent.messent_TelNumber
 where T_messent.user_Name in(1,2,3) order by messent_DateTime DESC

完整的