joining 3 tables?

[siti_nana]

helooo...

i have 3 tables -Recipes, Ingredients and Products.

Recipes table:
RecipeID -PK

Ingredients table:
IngredientID -PK
IngreRecipeID -Foreign key to Recipes table
IngreProductID -Foreign key to Products table

Table:
ProductID -PK

how do i join them into 1 recordset?

[Singularity.co.uk]

siti_nana

Try theSQL below:

SELECT *
FROM Recipes, Ingredients, Products
WHERE RecipeID = IngreRecipeID AND IngreProductID = ProductID


"siti_nana" <webforumsuser@macromedia.com> wrote in message
news:cvnejo$lk2$1@forums.macromedia.com...

> helooo...
>
> i have 3 tables -Recipes, Ingredients and Products.
>
> Recipes table:
> RecipeID -PK
>
> Ingredients table:
> IngredientID -PK
> IngreRecipeID -Foreign key to Recipes table
> IngreProductID -Foreign key to Products table
>
> Table:
> ProductID -PK
>
> how do i join them into 1 recordset?
>
>

[samkry]

select rec.*,ing.*,prod.* from recipe rec
join ingredient ing
on rec.recipeid=ing.recipeid
join product prod
on ing.productid=prod.productid
where

above sql will etract all fields from ur column u can have more specific
column by replacing the .* to ur column name