I am having my database in MS Access(I haven't work with access earlier),I write a simple join statement to retrieve data from tables but surprisingly it is throwing Syntax error.
So I created those tables in Sql and execute the same query and it is working fine there.
Is there syntax differences in Sql and Access.
If so then what should I change in following query,
select PM.Prod_Name,NV.Visit_Count,ST.Quantity,RT.Prod_Code as 'Rejection Reason'
inner join Next_Visit NV on NV.Prod_Code=PM.Prod_Code
left outer join Sale_Table ST on ST.Prod_Code=PM.Prod_Code
left outer join Rejection_Table RT on RT.Prod_Code=PM.Prod_Code