masri999
3/28/2007 5:47:00 PM
On Mar 28, 9:22 pm, "Brian" <barm...@amphenolpcd.com> wrote:
> I have the following query which returns data that is not the same in
> two columns:
>
> select ord_no, cus_no, bill_to_no, *
>
> from oeordhdr_sql
>
> where bill_to_no is not null and cus_no <> bill_to_no
>
> I need to create a query where it will take these results and change
> the bill_to_no to be the same as the cus_no. for every row. Any help
> is greatly appreciated.
>
> Brian
update oeordhdr_sql
set bill_to_no =cus_no
where bill_to_no is not null and cus_no <> bill_to_no