SQL Question

From: Michael Milliron <okana_at_email.msn.com>
Date: Thu, 5 Nov 1998 09:23:53 -0700
Message-ID: <OllQ$iNC#GA.176@upnetnews02.moswest.msn.net>

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 - 10:23:53 CST