Guest Posted February 25, 2003 Share Posted February 25, 2003 Hello, I am having problems creating a sql statement to accomplish the following: Table 1 - Newdata - New table filled with data. - field 1 - products_model - key field - field 2 - product_notes Table 2 - Products ( standard osc 2.2-ms1 products table - field 1 - products_model - key field - field 2 - new_notes_data field I need a statement to read table 1 and find the appropriate rows within the table 2 and if a match is found on product_model then update that specific line or lines with the data in table 1 - field 2. I can not get my sql statements to work. :x :crazy: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.