On Saturday 03 January 2004 09:20, John Coryat wrote: > Problem: I have a table that has a field I want to plug with a value > from other tables. [snip] > I would expect it to look something like this: > > update orderheader set total = (select sum(amount) from orderdetail > where orderdetail.orderno=orderheader.orderno) ;
Looks fine to me. In general, you can do something of the form: UPDATE ta SET a2 = (SELECT expr(b2) FROM tb WHERE b1=a1); NOTE - make sure you understand what happens when there is no b1=a1 and what that will mean to your particular setup. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
