Im getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'rs.pathnames=cl.path_groups Inner Join Alternative_medicine ALM ON rs.pathnames=ALM.PATH_Group_Name'.
when running this sql statement:
Select rs.* From Reduced_Sample_for_Demonstration RS Inner Join Claims_Rates CL ON rs.pathnames=cl.path_groups Inner Join Alternative_medicine ALM ON rs.pathnames=alm.PATH_Group_Name
*rs.pathnames,cl.path_groups and alm.PATH_Group_Name are the related columns, although their column names do not correspond, their values are the same and the data types of all these columns are text. I simply want to join all 3 tables based on this column. I have a WHERE clause Im going to add, but first I simply want to get this join working, but I cant figure out what the problem with this query is.
Thanks for any help
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'rs.pathnames=cl.path_groups Inner Join Alternative_medicine ALM ON rs.pathnames=ALM.PATH_Group_Name'.
when running this sql statement:
Select rs.* From Reduced_Sample_for_Demonstration RS Inner Join Claims_Rates CL ON rs.pathnames=cl.path_groups Inner Join Alternative_medicine ALM ON rs.pathnames=alm.PATH_Group_Name
*rs.pathnames,cl.path_groups and alm.PATH_Group_Name are the related columns, although their column names do not correspond, their values are the same and the data types of all these columns are text. I simply want to join all 3 tables based on this column. I have a WHERE clause Im going to add, but first I simply want to get this join working, but I cant figure out what the problem with this query is.
Thanks for any help