Michael Stassen wrote:
First, I think the LEFT JOIN is unnecessary. Rows in members without a
corresponding row in active will not have acct_days>0 (it'll be NULL),
so, by using LEFT JOIN you are (possibly) creating rows only to discard
them. I think a simple join will do.
You want a multi-ta
First, I think the LEFT JOIN is unnecessary. Rows in members without a
corresponding row in active will not have acct_days>0 (it'll be NULL), so,
by using LEFT JOIN you are (possibly) creating rows only to discard them. I
think a simple join will do.
You want a multi-table update:
UPDATE me
