Re: Slick way to update multiple tables.

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 4/1/21 11:16 AM, Theodore M Rolle, Jr. wrote:

I SELECT items from three tables.

It seems that the only way to put updated fields into their proper table is to query each field, then UPDATE each table.

Am I missing something here?

Is there a way to do this automatically?

    Did you join the three tables when querying?

--
Angular momentum makes the world go 'round.