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 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 / *** / 9145S05001 > > I've tried using the 'UPDATE' query but as the 'LIMIT' function doesn't > work with 'UPDATE' every time I run the query it updates every row with > the same 'products_id' information! > > Please can somebody help??? > > P.S. I'm running MySQL 4.0.26 using phpMyAdmin > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]