sql join help

[brianv]

i have 3 tbls

Recipes
RecipeId autoNumber
Recipe text


one 2 many

RecipeIngredients
RecipeIngredientsId autoNumber
RecipeId number
IngredientId number


many 2 one

Ingredients
IngredientId autoNumber
Ingredient text


what would the select sql look like to get all the Ingredients.Ingredient
for a given Recipes.RecipeId

 

[warrior]

I've found the easiest way to build an sql statement is to go into
queries, select your tables and create the relationships (if they
aren't established yet). Select the fields and the criteria. On the
menu there is a drop down box for view.... select the sql view. I
usually copy and past this into notepad so I can work with it.

good luck