I am learning and I get help here but now a days, when I post, I pray that a particular guy who post reply which has no explanation some random code he thinks works, no reply and moves on .. but he denied me an opportunity to get help as no one is ready to answer even though I send reply pleading help.
I have 4 questions I could have get help but no other person helps me because this guy responded. Please advice.
I have 2 tables, the first table has LEADS with a creation date field and the second table has CUTOMER with a conversion date field.
I need to create a new field in the LEADS table of type date that includes all the values of the Date-creation field and in case there are null values, look for the date-convertion field in the CUSTOMER table and paste it in the new field of the LEADS table