Hi everyone,
Apologies about the basic SQL query, but I was wondering if someone could help? I'm only 4 months in with my SQL and still very much a beginner! For some reason I've been going in circles trying to update a field but unfortunately I get the red wiggly line of doom on every configuration I try.
I would like to update the allow_html field in the T_EADDRESS table. I have the constituents I'd like to change this on in a list, so I've been trying to link T_EADDRESS and T_LIST_CONTENTS.
What would be the best way to do this please?
Thanks in advance!
Eleanor
HI Eleanor,No worries. This is one of the best places to get tips and learn. How about something like ...
update T_EADDRESSSet html_ind = 'Y'where customer_no in (select customer_no from T_LIST_CONTENTS where list_no = 1234)
Thank you!