Re: SQL Question

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Thu, 5 Nov 1998 13:35:07 -0500
Message-ID: <71sr2n$3bf$1@client2.news.psi.net>

Hi Michael,

Try the following (I assume I have the syntax right but --- ).

UPDATE MWM_noiselect M
SET branch_name ,
    branch_address1,
    branch_address2    =

(SELECT b.branch_name,

    b.branch_address1,
    b.branch_address2
FROM branch b
WHERE (M.MWM_noiselect.bank = b.branch.client_no

     AND M.MWM_noiselect.rpt_branch = b.branch.branch_no)

regards

Jerry

Michael Milliron wrote in message ...
>I am trying to do an update and I am not able to get it to work - (my SQL
>books are on the way)
>
>I'd appreciate any advice:
>
>Two tables
>1) branch - contains branch data
>2) mwm_noiselect - a table created for reporting, need to fill in the
branch
>data
>
>This is my SQL at the moment (I cut it short and didn't list all the
>fields - I know I'm wrong in the basic structure for ansi SQL. Of course
it
>works in Access - Jet SQL):
>
>UPDATE MWM_noiselect, branch
>SET MWM_noiselect.branch_name = branch.branch_name,
>MWM_noiselect.branch_address1 = branch.branch_address1,
>MWM_noiselect.branch_address2 = branch.branch_address2
>WHERE (MWM_noiselect.bank = branch.client_no AND MWM_noiselect.rpt_branch =
>branch.branch_no)
>
>Thanks in advance for any advice.
>
>Mike
>mikem_at_msamail.com
>okana_at_msn.com
>
>
>
Received on Thu Nov 05 1998 - 12:35:07 CST