SQL query help.

1. Give the ingredient name, amount, and measurement description for ingredients found in Yorkshire Puddin.

2. List the names only of ingredients NOT found in a recipe ( use LEFT OUTER JOIN and looked for NULL values)

Tables are below.

mysql> use mortals recipe; Database changed mysql> show tables; I Tables in mortals recipe l l ingredient classes l ingredients I measurements I recipe classes l recipe ingredients I recipes 6 rows in set (0.01 sec) mysql> desc ingredientClasses; l Field l Type I Null I Key Default I Extra l IngredientClassID | smallint (6) NO I PRI I NULL I I ICDescription varchar (255) I YESI NULL 2 rows in set (0.03 sec)