Hi I have some basic SQL that I use to check for duplicates. What I need to do is write the results of the code to be a "1"in the same row. I.e I want to be able to stamp the results of this "Check duplicates" as 1 1 in a column call "stamp". Im new to all this thanks :)
select count(*) from activecampaign.em_subscriber
Inner join activefeed.6_subscriber
ON em_subscriber.email = 6_subscriber.`Email Address`
The above gets me my dupes now I just need to write 1 in the stamp columns for those contained in the above results
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.