Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

??? mysql coding ???


Guest

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...