[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