SQL statement needed

visionetv
visionetv used Ask the Experts™
on
Hello Experts;

I have two database tables "OrderNumber" and "SupplierList". I want to UPDATE (overwrite the data) in the cells of the "ReorderNumber" column in the SupplierList table with the data from the "ManID" column in the OrderNumber table WHERE the strings in the cells in the "Description" column of the SupplierList table match the strings in the "Description" column of the OrderNumber table.

I'm new to SQL and need an example.

Thank you,
Visionetv
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
this helps you

UPDATE SupplierList
SET ReorderNumber = ON1.ManID
FROM SupplierList  SL inner join OrderNumber ON1
ON SL.Description = ON1.Description

visionetvIT Consultant

Author

Commented:
Sarabhai;

The SQL statement worked great... thank you for the solution and the lesson, I'll award you the points.

Thanks again,
Visionetv

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial