updating record question

From: Joe D <joed_at_icoms.com>
Date: Thu, 23 Dec 1999 15:15:11 -0500
Message-ID: <3862864b$1@News.Destek.net>

I have the following query which gives me the following output.

select s.key_store_seqid "store id", t.order_number "order numb", t.order_status "status"

     2> from store s, txorder t
     3> where
     4> s.store_id = t.store_id
     5> and t.order_number < 100008
     6> and t.order_number >= 100000
     7> and s.key_store_seqid = 500513
     8>

store id order numb status
---------- ---------- ----------

    500513     100000          2
    500513     100001          2
    500513     100002          2
    500513     100003          2
    500513     100004          2
    500513     100005          2
    500513     100006          2
    500513     100007          2

8 rows selected.

What I need to update is the status column. I need to change the 2 to a 4. I am having problems
with the query syntax. I'm a newbie to sql queries and I'm not sure how to join the two tables in a update query.
Any help would be great.

Thanks and Happy Holidays.

Joe Received on Thu Dec 23 1999 - 14:15:11 CST