Re: What will this SQL DO?

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Although you don't sat what database you're on, I guess I can say it
will do nothing, exept give a syntax error.
What you can do however is, suppose you want to delete ps_jrnl_ln, is:

delete ps_jrnl_ln
from ps_jrnl_ln LN, ps_jrnl_header HDR
where LN.BUSINESS_UNIT = HDR.BUSINESS_UNIT
and LN.journal_id = HDR.journal_id
and LN.JOURNAL_DATE = HDR.JOURNAL_DATE
and HDR.Journal_id = 'APINF'
and HDR.jrnl_hdr_status='N'

Test it before you try, but syntax-wise it should work.

Arjan


--- Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM> wrote:
> delete from ps_jrnl_ln LN, ps_jrnl_header HDR
> where LN.BUSINESS_UNIT = HDR.BUSINESS_UNIT
> and LN.journal_id = HDR.journal_id
> and LN.JOURNAL_DATE = HDR.JOURNAL_DATE
> and HDR.Journal_id = 'APINF'
> and HDR.jrnl_hdr_status='N'\
>
>
> Thanks
> SE


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/