RE: SQL - how do I do this ?

Piece of cake, Peter.  Thank you.  Done! 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Levy
Sent: Tuesday, August 08, 2006 1:43 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL - how do I do this ?

Probably something like this:

update ITEMMAST set HRZDAY = 'etc' where PT# in (select PT# from FILE#2
where MODELCD = 'BH01')
  ----- Original Message -----
  From: Don Cavaiani
  To: midrange-l@xxxxxxxxxxxx
  Sent: Tuesday, August 08, 2006 2:14 PM
  Subject: SQL - how do I do this ?


  I struggle with some of this SQL (Interactive).

  I want to set a specific Horizon Days value, in certain records only,
in my Item Master file.  I need to fetch a second file, also keyed by
the PT#, and check a MODEL CODE contained there.  Only when that Item
Master Part number record  HAS A MODEL CODE = to  "BH01" in that field
in the 2nd file - THEN that is when the Horizon days field in the Item
Master file should be set to the specific value.

  Don F. Cavaiani
  IT Manager
  Amerequip Corp.
  920-894-7063
   
  'Treat every person with kindness and respect, even those who are rude
to you. Remember that you show compassion to others not because of who
they are but because of who you are.'--Andrew T. Somers 

  "When faced with the choice of being 'right' or being 'kind', choose
the kind option every time."


  --
  This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
  To post a message email: MIDRANGE-L@xxxxxxxxxxxx
  To subscribe, unsubscribe, or change list options,
  visit: http://lists.midrange.com/mailman/listinfo/midrange-l
  or email: MIDRANGE-L-request@xxxxxxxxxxxx
  Before posting, please take a moment to review the archives
  at http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.