On Thu, 2005-06-23 at 14:48 -0400, Mitchell Vincent wrote: > UPDATE customer_detail SET customer_id = (SELECT customer_id FROM > customers WHERE customers.customer_name = customer_detail.customer_name); >
This should work. Are you having problems? You'll need version 3.1.0 or later. -- D. Richard Hipp <[EMAIL PROTECTED]>