Re: SQL Question

Absolutely Perfect Lisa!!! - thanks!!!!!!

@}----}------

Mike

Lisa F. Miller wrote in message <3641E578.BF1BA7CC_at_ornl.gov>...
>Try this:
>
>UPDATE MWM_noiselect
> SET (MWM_noiselect.branch_name,
> MWM_noiselect.branch_address1,
> MWM_noiselect.branch_address2) =
> (SELECT branch.branch_name,
> branch.branch_address1,
> branch.branch_address2
> FROM branch
> WHERE branch.client_no = MWM_noiselect.bank
> AND branch.branch_no = MWM_noiselect.rpt_branch);
>
>May need some tweeking (WHERE clause on the UPDATE part?)....
>
>Hope this helps,
>Lisa
>
>
>
>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 - 12:57:55 CST