Re: SQL Question

From: Dennis Chebotarev <tdennis_at_iname.com>
Date: Thu, 05 Nov 1998 09:35:02 -0800
Message-ID: <3641E1C6.C7AE1CD@iname.com>

You can't update two table at once.

Use this:

UPDATE MWM_noiselect
SET branch_name = branch.branch_name,

        branch_address1 = branch.branch_address1,
        branch_address2 = branch.branch_address2

WHERE (bank, rpt_branch) IN
 (SELECT client_no, branch_no FROM branch);

Best regards

Dennis.

Michael Milliron wrote:

> 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 - 11:35:02 CST