Lester Caine wrote:

> Carlo Bergamini 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??
>
> '1'
> It simply provides a return from the select if a record exists. EXISTS
> does not need any field information, it has a yes/no for the record, so
> '1' is just a dummy field.

Thank Lester, Carlo.

>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
> *Yahoo! Groups Sponsor*
> <http://us.ard.yahoo.com/SIG=129jkocgs/M=324658.6070095.7083352.3001176/D=groups/S=1705115386:HM/EXP=1108978169/A=2343726/R=0/SIG=12ir5e5af/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108891769857672>
>
>
> Get unlimited calls to
>
> U.S./Canada
>
> <http://us.ard.yahoo.com/SIG=129jkocgs/M=324658.6070095.7083352.3001176/D=groups/S=1705115386:HM/EXP=1108978169/A=2343726/R=1/SIG=12ir5e5af/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108891769857672>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>