[thelist] Relational DB
rudy
r937 at interlog.com
Mon Feb 4 08:15:00 CST 2002
> I have a 4 tables with simple relationships among them (table 1
> has 1 field from table 2, one field from table 3 and table 3 has
> one field from table 4). The problem I am having is finding out
> how to write to all tables at once.
hi faye
you cannot do it in one sql statement
the next best thing is to do it in one database call, where 4 sql
statements are passed over at the same time
worst case is 4 separate database calls
more i cannot say without seeing the table definitions and the updates you
are trying to do
rudy
More information about the thelist
mailing list