I have different Forms (data sources) with different fields. Basically we run contests on our website and use the have email addresses of people that visit our website. Some of those forms have address, state zip etc fields but these are not required – so we have a lot of nulls.
Question: what code (SQL) do I write to automatically append or download data into one main table – that would look for duplicate e-mail and fill in the blank fields on that row. – The e-mail address is my primary key.
