SELECT statement problem

[samvb]

Hi,

I have this 3 tables:

tblProducts: productid,producntname
tblIngredient:ingredientid,ingredientname
tblProductsIngredients:autoid,productcode,ingredientcode,amountneeded
 

Products are made by certain amount of ingredients. I can add new products and all but am having problem wit updating product. During editing product, I want to list ingreidents that are not already added to the product along with ingredients (and their amounts) that are already specified for the product. I tried this code but it only returns already specified products while sometimes adds only one new ingredient to the list to be added:

 
$strsql="SELECT * FROM viewexistingandnewingredientswithproducts WHERE productcode=$id OR productcode IS NULL";
 
}
 

where viewexistingandnewingredientswithproducts is defined as

 
select * from tblingredients,tblProductsIngredients where ingredientid=ingredientcode
 

[Rabbit]

What you've done is basically an inner join. It will never show ingredients that aren't in the product. What you want to do it outer join the tables.