Get data from SharePoint List and SQL Table - compare them with powershell and print another data in SharePoint

I want to make a script which will get data from sharepoint list (from specific column) and also get data from SQL table (from specific column) and compare them, if will be value true then get another specific column value from SQL table and set it to Sharepoint list.

I will compare identification number value from sharepoint list with identification number from SQL table, if value will be true then another column that falls under the identification number in SQL table will be added to SHP list in compared value (identification number)

This need to be done with powershell.

Any suggestion how to make it work ?

Welcome to the forum. :wave:t4:

If this is an internship assignment or homework question we try to avoid assisting with those as the first port of call should be your tutor or supervisor.

If it is not you should keep in mind this forum is for scripting questions rather than script requests. We do not write customized and ready to use scripts or solutions on request.

What have you tried so far? We expect you to make an own attempt to get your task done or to solve your problem. If you have done so already please document here what exactly you have done and show your code. Then we probably might be able to help you step further.

To get you started you may start reading the following help topics: