-2

I'm trying to do some join operations in sql access but I keep on getting the join operation error. At first it was just the JOIN alone, but then I realized I had to add the INNER which I did but it didn't resolve the error.

Code below:

SELECT Formula.*, Ingred.[Europe Ban] 
FROM [Ingred]  
INNER JOIN Ingred ON Formula.[Ingredient] = Ingred.Ingredients;
The Impaler
  • 45,731
  • 9
  • 39
  • 76
mark7328
  • 41
  • 5

1 Answers1

2

Presumably, you want Formula in the FROM clause, not Ingred twice:

SELECT Formula.*, Ingred.[Europe Ban]
FROM Formula INNER JOIN
     Ingred
     ON Formula.[Ingredient] = Ingred.Ingredients;
Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
  • that solved the issue but now im getting cannot join memo ole or hyperlink object Formula.ingredient = Ingred.Ingredients my relationships should be correct – mark7328 Aug 06 '18 at 14:09
  • You can't JOIN on Memo (Long Text) fields, and if you are trying, your table design is most probably wrong. @mark7328 – Andre Aug 06 '18 at 14:18