Problem with UPDATE syntax when updating multiple tables

2005-12-15 Thread Matthew Batt
Hi I need to update the 'products_id' field (shown below) by copying data from a separate table but I can't use the 'UPDATE' query as each 'product_id' entry relates to a specific 'products_model' row. id / assembly_no / products_id / products_model 1 / 2313 / *** / CASEACERENTRY2 2 / 2313 /

Re: Problem with UPDATE syntax when updating multiple tables

2005-12-15 Thread Gleb Paharenko
Hello. Please, could you provide the CREATE statement for you tables and describe the relationships between their fields (it will be good if you include sample data as well). Matthew Batt wrote: Hi I need to update the 'products_id' field (shown below) by copying data from a