Helen Borrie wrote:

>
> DELETE FROM RECIPES R
> WHERE EXISTS
> (SELECT 1 FROM INGREDIENTS
> WHERE I.R_ID = R.R_ID
> AND I.NAME='RICE')
>
> And, yes, you can use a subquery in either the SET value or the search
> value of an update query. I can't offer a sensible example from your
> current example, though. Give some detail about what you'd want to do in
> such an update.
>
> ./heLen
>

Hi Helen, have a good day.
Sorry for the dumb question but...what 1 represents in the query??

Carlo.