Re: [sqlite] Update/Join Howto?

2005-06-23 Thread Dennis Cote
Mitchell Vincent wrote: D. Richard Hipp wrote: On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote: Shoot! I meant to say that I need it to work with 2.8.16 (which was the entire issue!).. *crosses fingers* any way to make that happen? Not really. Version 2 is in maintenance -

Re: [sqlite] Update/Join Howto?

2005-06-23 Thread Mitchell Vincent
D. Richard Hipp wrote: On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote: Shoot! I meant to say that I need it to work with 2.8.16 (which was the entire issue!).. *crosses fingers* any way to make that happen? Not really. Version 2 is in maintenance - meaning bugfixes only. All

Re: [sqlite] Update/Join Howto?

2005-06-23 Thread D. Richard Hipp
On Thu, 2005-06-23 at 15:32 -0400, Mitchell Vincent wrote: > Shoot! I meant to say that I need it to work with 2.8.16 (which was the > entire issue!).. > > *crosses fingers* any way to make that happen? > Not really. Version 2 is in maintenance - meaning bugfixes only. All new features go

Re: [sqlite] Update/Join Howto?

2005-06-23 Thread Mitchell Vincent
D. Richard Hipp wrote: 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

Re: [sqlite] Update/Join Howto?

2005-06-23 Thread D. Richard Hipp
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.