Re: SQL trigger question

From: "walker.l2" <walker.l2@xxxxxxxxxxxxxx>
Date: 31 May 2007 08:26:54 -0700

Presumably usrprf is never null, so couldn't you do something like
this:
UPDATE store.pacs260 SET usract='N'
WHERE usrprf = (SELECT padata FROM store.peis480h
WHERE pa#=new.em# and paid='AS400')

.

Follow-Ups:
- Re: SQL trigger question
  - From: Hal
- Re: SQL trigger question
  - From: Hal

References:
- SQL trigger question
  - From: Hal
- Re: SQL trigger question
  - From: Graybeard
- Re: SQL trigger question
  - From: Hal

Prev by Date: Re: SQL trigger question
Next by Date: Re: SQL trigger question
Previous by thread: Re: SQL trigger question
Next by thread: Re: SQL trigger question
Index(es):
- Date
- Thread