CREATE OR REPLACE VIEW Not Working?

[VikR]

This works fine, with 175 rows returned:

SELECT id, NDB_No, min, max, final_amount, fz_units_id, fz_score, used_in_last_food_plan, meal_type, user_prefs_for_foods.FlavorZoom_Food_ID_No, brand_name, calories, carb_grams, date_added, description, fat_grams, gm, id_of_user_who_added_this, let_other_people_use_this_info, Long_Desc, number_of_gms_or_ml, number_of_units_per_serving, product_name, protein_grams, sugar_grams, units_of_measurement FROM user_prefs_for_foods JOIN new_foods_added_by_users ON user_prefs_for_foods.FlavorZoom_Food_ID_No = new_foods_added_by_users.FlavorZoom_Food_ID_No WHERE (user_prefs_for_foods.id = 1) AND (user_prefs_for_foods.FlavorZoom_Food_ID_No > 0);

But, when I try to store the results of the exact same query, using CREATE OR REPLACE VIEW, I get an empty result set:

CREATE OR REPLACE VIEW UserPrefsPlusNewFoods AS SELECT id, NDB_No, min, max, final_amount, fz_units_id, fz_score, used_in_last_food_plan, meal_type, user_prefs_for_foods.FlavorZoom_Food_ID_No, brand_name, calories, carb_grams, date_added, description, fat_grams, gm, id_of_user_who_added_this, let_other_people_use_this_info, Long_Desc, number_of_gms_or_ml, number_of_units_per_serving, product_name, protein_grams, sugar_grams, units_of_measurement FROM user_prefs_for_foods JOIN new_foods_added_by_users ON user_prefs_for_foods.FlavorZoom_Food_ID_No = new_foods_added_by_users.FlavorZoom_Food_ID_No WHERE (user_prefs_for_foods.id = 1) AND (user_prefs_for_foods.FlavorZoom_Food_ID_No > 0);

What am I missing?

Thanks very much in advance to all for any info.