[thelist] Relational DB

> 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