Re: [SQL] UPDATE/INSERT on multiple co-dependent tables

2004-11-14 Thread Karsten Hilbert
> Is it possible for an UPDATE/INSERT query string to function in such a > way that it requires two like fields in different tables to be equal > to/'in sync with' one another: > > Example: I have two tables: registration & schedules > they both record a class_id, start_date, end_date... I

Re: [SQL] UPDATE/INSERT on multiple co-dependent tables

2004-11-09 Thread Stephan Szabo
On Tue, 9 Nov 2004, Ferindo Middleton, Jr wrote: > Is it possible for an UPDATE/INSERT query string to function in such a way > that it requires two like fields in different tables to be equal to/'in sync > with' one another: > > Example: I have two tables: registration & schedules > they both